Downgrading MySql!

[setareh]

I had to change my hosting company,
my previous company had MySql 5, and new one has MySql 4,

I dumped my db and moved that to new server, and tried use bigdump script to extract my back.sql file, and I saw this error:

Error at the line 42: ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Query: CREATE TABLE `mt_author` ( `author_id` int(11) NOT NULL auto_increment, `author_name` varchar(50) NOT NULL default '', `author_type` tinyint(4) NOT NULL default '0', `author_nickname` varchar(50) default NULL ....
MySQL: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 20

and for another db I saw:

Error at the line 26: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;

Query: CREATE TABLE `banned` ( `banip` varchar(15) collate utf8_persian_ci NOT NULL default '', `banreason` varchar(255) collate utf8_persian_ci NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;

MySQL: You have an error in your SQL syntax near 'collate utf8_persian_ci NOT NULL default '', `banreason` varchar(255) collate ' at line 2

How can solve this problem?

[jatar_k]

you could strip all your creates down to basics

CREATE TABLE `banned` ( `banip` varchar(15) NOT NULL default '', `banreason` varchar(255) NOT NULL default '' );

and see if that works

[Andrew Bassett]

Losing MySQL 5 to version 4 is a major ouchface; I would never wish that upon any enemy.

[setareh]

I had to write a code for transfering my DB, and then some code for repairing and then some manual activity to fix errors!
that was terrible,
never downgrade anything!