Fail to recover from mysqldump backup file
Posted by:
yudong.sun
Date: April 17, 2005 10:04AM
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:
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
Views
Written By
Posted
Fail to recover from mysqldump backup file
5341
April 17, 2005 10:04AM
3037
April 18, 2005 08:17AM
3073
April 19, 2005 03:31AM
2876
April 19, 2005 03:58AM
2971
April 19, 2005 08:31AM
2871
April 20, 2005 03:32AM
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.