Moving dump from 3.23.58 to 4.0.25-standard

[cmayo]

Forgive me if this has been asked to death, but I couldn't turn up the answer in a forums search.

I'm moving databases from 3.23 to 4.0.25 and running into a syntax problem when importing the 3.23 data into 4.0:

ERROR 1064 at line 297: 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 'default NULL,
paid tinyint(1) default NULL,
seasonYear int(

The statement it's choking on is:

REATE TABLE Payment (
id int(11) NOT NULL auto_increment,
playerId int(6) default NULL,
check char(10) default NULL,
paid tinyint(1) default NULL,
seasonYear int(4) default NULL,
season tinyint(1) default NULL,
PRIMARY KEY (id)
) TYPE=ISAM PACK_KEYS=1;

I'm using a straight mysqldump with no switches... is there some sort of compatibility mode I should be using that'll make 4.0 accept the 3.23 code?

TIA,

Chuck Mayo

 

[TonyGroves]

CHECK is a reserved word. If you can't change the name, then you'll have to enclose it in "backticks" (grave-accent characters):[tt] `check` CHAR(10)[/tt]

Also, I think support for ISAM tables has been dropped in recent versions of MySQL. You might like to upgrade to MyISAM or one of the other table types, which in any event offer much better performance than ISAM.

 

[cmayo]

Tony, thank you very much. I'd have been here all day puzzling that out. Worked like a charm.