how to restore into a 3.23.58 env. from a 4.1.9 env

[mark ginsburg]

Hello I created, using mysqldump, a backup.sql file. I am trying to restore a bunch of tables under a single database.

The database in 4.1.9 has InnoDB engine and latin 1 charset.

In order to restore in an older 3.23.58 environment, I replaced all instances of InnoDB in the sql file with MyISAM. What else do I need to do?

Do I need to delete entirely the charset Latin1 line everywhere?

I get:

ERROR 1064 at line 20: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='cpt codes from AMA 10/2005'' at line 6


Here is the relevant section:

*********************************************************

DROP TABLE IF EXISTS `CPT_2006`;
CREATE TABLE `CPT_2006` (
`CPT_Code` varchar(5) NOT NULL default '0',
`CPT_Desc` text NOT NULL,
`Unit_Charge` decimal(5,2) default NULL,
PRIMARY KEY (`CPT_Code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='cpt codes from AMA 10/2005';


***********************************************************

Is Latin1 the source of my problem or something else?


Thanks


Mark