Mysql 4.1 & 3.2 - Problem when restore database.

[vBB-vietnam]

In Localhost: mysql 4.1, default-storage-engine = INNODB, default-character-set=utf8
My host: mysql 3.2, default-storage-engine=MyISAM, default-character-set=iso-8891-1

How to restore data from localhost to my host ? I can't...

THank !

[Zachery]

You need to drop the mysql 4.1 specific text.

I'd seriously URGE youir host to upgrade to MySQL 4.1 or 5.0 because 3.x is over 5-6 years old now.

[B?-Y?u]

In Localhost: mysql 4.1, default-storage-engine = INNODB, default-character-set=utf8
My host: mysql 3.2, default-storage-engine=MyISAM, default-character-set=iso-8891-1

How to restore data from localhost to my host ? I can't...

THank !
Hi vbb-vietnam !
You can backup your database use phpmyadmin, when backup, remember chose SQL export compatibility is MYSQL323. Then, you can use bigdump (download attach file) for restore your database.

Other way, you can backup & restore data use mysqldumper (www.mysqldumper.de).
Hope, i can help you :)
bE-yEu