MySQL Problem

[comptech520]

Hello,

On my old server I had MySQL 4.XX

On my server I have MySQL 3.XX

I did a dump of the databases on my old server, in SQL format.
I am using PHPmyAdmin to load the databases in the new server, when doing so I get this error:

#1064 - You have an error in your SQL syntax near 'ENGINE=3DMyISAM =DEFAULT CHARSET=3Dlatin1' at line 14=20

I DON'T have the option to upgrade MySQL, any ideas?

Thanks

 

[wagnerch]

In the mysql dump file (sql file) strip off DEFAULT CHARSET='latin1' from the create table statement and it should be fine.