MySQL Forums
Forum List  »  Backup

mysqldump > restore problem
Posted by: Florian Roth
Date: March 25, 2006 04:08AM

I dumped my complete database like this:

mysqldump -A --add-drop-table --user=dump --password=+dump14 > mysql_backup_2503.sql

After that, i tried to restore the backup and recieved this message

mysql -p < mysql_backup_2503.sql
Enter Password: *********

ERROR 1064 at line 143: 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 'option varchar(50) NOT NULL default '',
ordering int(11) NOT

How is that possible? Wheres the problem? I am using the same database as before. Why do I have this syntax problem? Or is it another prob?

My Version:
mysql -V
mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)


Help!

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump > restore problem
5181
March 25, 2006 04:08AM
2857
March 25, 2006 04:30AM


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.