Bug #6004 Syntax error in MySQL dumps
Submitted: 10 Oct 2004 7:46 Modified: 11 Nov 2004 11:46
Reporter: Carl Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:3.23.58 OS:Linux (Fedora Core 1)
Assigned to: CPU Architecture:Any

[10 Oct 2004 7:46] Carl 
Description:
I did a mysql dump a couple of days ago, when i try to import i get a 1064 error. I think this relates to Bug #1066. New to mysql, sorry i can't give more info.

How to repeat:
not really sure other than dump and # mysql -u username -ppassword database_name < FILE.sql
[11 Oct 2004 11:46] MySQL Verification Team 
Hi,

Thank you for the report.

First of all, you set Category to "MySQL Administrator", but in the report you said only about mysqldump and restore table using mysql command-line client program.
Did you create dump file using MySQL Administrator program or what?

Regarding to the eror #1064, check that your database, table, column or index names are not reserverd words:
http://dev.mysql.com/doc/mysql/en/Reserved_words.html
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".