error when importing mysqldump file
Posted: Wed Mar 30, 2005 1:56 pm
I have created a backup batch file on my server that uses mysqldump to create the .sql. However, when I try to load it into mysql, I get the following error:
This is the mysqldump statement I am using:
If anyone sees what it's doing wrong, please advise. Thank you.
Swede
This is the statement in question. I can't see why it doesn't work. And I definitely can't understand why mysqldump is creating bad syntax. I am using mysql 4.0.23 on a windows 2003 server to create the sql file. Same version is being used to import it.ERROR 1064 at line 234544: 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 'FieldName6 tinyint(1) NOT NULL default '0', FieldName7 double(4,2) Not
Code: Select all
CREATE TABLE ship_promos (
FieldName1 char(10) NOT NULL default '',
FieldName2 tinyint(1) NOT NULL default '0',
FieldName3 double(4,2) NOT NULL default '0.00',
FieldName4 tinyint(1) NOT NULL default '0',
FieldName5 double(4,2) NOT NULL default '0.00',
FieldName6 tinyint(1) NOT NULL default '0',
FieldName7 double(4,2) NOT NULL default '0.00',
PRIMARY KEY (ShipPromoID)
) TYPE=MyISAM;Code: Select all
mysqldump -u USERNAME -pPASSWORD --add-drop-table --extended-insert DATABASENAME > output.sqlSwede