MySQL Forums
Forum List  »  MySQL Administrator

Syntax error in MySQL dump file
Posted by: Veerasamy Kaunder
Date: May 20, 2013 08:38AM

Hi,
I faced an issue in mysql dump restoration. Upon debugging found that the backup file had syntactical error in one of the insert lines.
example: There is a datetime value partially written ('2)and again correctly specified as given in below insert statement.

Insert into Tab1 Values (xx,xx,'2, '2013-05-20 00:00:00',....)

Because of this syntax error, the backup file failed to restore.
can anybody share the knowledge how that is possible when mysqldump command is used for backup.

Regards,
Veera

Options: ReplyQuote


Subject
Written By
Posted
Syntax error in MySQL dump file
May 20, 2013 08:38AM


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.