On Wed, 28 Nov 2007 12:57:25 +0100 (CET) "Alicia Amadoz"<[EMAIL PROTECTED]> wrote:
> 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 If mydb_backup.sql is the dump file, try: mysql -u root -p mydb < mydb_backup.sql mydb_backup.sql is populated with sql statements that need to be ran using mysql. ------ _|_ (_| | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
