Hi , U Can try using this option.
Login into database Type as :- \. /tmp/mydb_backup.sql Hope this will help you out. -----Original Message----- From: Alicia Amadoz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 28, 2007 5:27 PM To: mysql@lists.mysql.com Subject: Problem recovering from mysqldump Hi, I want to copy some databases to a new server and I have tried to backup my databases with mysqldump in the old server, then copy those files to the new server and recover them with mysqldump again. The problem is that when doing, >mysqldump -u root -p mydb < mydb_backup.sql the message that appears is -- MySQL dump 10.11 -- -- Host: localhost Database: dbcontrol -- ------------------------------------------------------ -- Server version 5.0.45 /..../ -- Dump completed on 2007-11-28 11:13:13 But when entering mysql in the new server, no table has been restored although it says that dump has been completed. The old server version is 5.0.21 with mysqldump 10.10. Any idea how to solve this and copy my databases properly? Thanks for your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]