MySQL Forums
Forum List  »  Backup

Help restoring a database
Posted by: Todd Eades
Date: December 31, 2004 06:51PM

I'm having trouble restoring a database that was backed up a new version of mysql. Here are the details:

Details of old server:
Server Type WINNT
MySQL 4.1.7-nt

Details of new server:
Server Type FreeBSD
MySQL 4.0.18-log

I used the command line program to dump and to attemp the restore. I used this command to drump:
mysqldump --opt -Q -u dbusername -p databasename > /path/to/backupname.sql

and this command to restore.
mysql -u dbusername -p databasename < /path/to/backupname.sql

I'm getting this error:
ERROR 1064 at line 10: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '"mt_author" (
"author_id" int(11) NOT NULL auto_increment,

Is the older srever really not able to handle this....the new server isn't that newer.

Thanks for any assistance.

Options: ReplyQuote

Written By
Help restoring a database
December 31, 2004 06:51PM
January 02, 2005 06:42PM
January 03, 2005 03:56PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.