mysqldump > restore problem
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!
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.