MySQL Forums
Forum List  »  MySQL Administrator

Error reading dump
Posted by: Admin cpb
Date: July 07, 2009 01:47AM

Hello,

Getting this error while trying to import dump:

ERROR 1064 (42000): 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 'varchar(255) NOT NULL default '',
val longtext NOT NULL,
PRIMARY KEY (id)
)' at line 4

-------------------------------------------------

CREATE TABLE vertalingen (
id int(4) NOT NULL auto_increment,
lang char(2) NOT NULL default '',
key varchar(255) NOT NULL default '',
val longtext NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

The dump is from a MySQL 3.23 server and needs to be imported in a MySQL 5.0.32 server.

Can anyone help me?

Thanks....

Options: ReplyQuote


Subject
Written By
Posted
Error reading dump
July 07, 2009 01:47AM


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.