Fail to recover from mysqldump backup file
Posted by:
yudong.sun
Date: April 17, 2005 10:06AM
I used mysqldump --add-drop-table to back up a big database. Now I fail to restore the database from the backup file with the error:
$ mysql MyDB < backup.sql
ERROR 1064 at line 640052: 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 'Primary (comparison_id),
KEY seqids (ref_nucleo_id,qry_nucleo
The backup file is created by mysqlsump which is as large as 18G. I don't have another copy of the database. Is there any method to rescue this trouble?
My mysql is Ver 12.22 Distrib 4.0.18, for pc-linux-gnu (i686).
Many thanks.
Subject
Written By
Posted
Fail to recover from mysqldump backup file
April 17, 2005 10:06AM
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.