Import data from MySQL 5.0 into MySQL 3.23

Recently, you need to export the database under Mysql5.0 and then import it into the MySQL 3.23 database.

I use the following methods:

$ mysqldump-u root--skip-comments--compatible=mysql323--databases db1 DB2 db3 > Mydump.sql

Import on another server (MySQL 3.23.58):

Mysql> Source/path/mydump.sql

Always unsuccessful, such or such a mistake. Mysqldump parameters have been changed, not found suitable.

After several setbacks, the problem solved:

Oh, forgot to specify the Character-set. Because both sides have to be specified.

$ mysqldump-u root--default-character-set=xxxx--skip-comments--compatible=mysql323--databases db1 > Db1.sql

Import on another server (MySQL 3.23.58):

$ mysql-u Root--default-character-set=xxxx

Mysql> Source/path/db1.sql