Import data under MySQL5.0 to low version _ MySQL

Import data under MySQL5.0 to the lower version. recently, you need to export the database under Mysql5.0 and then import it to the database of mysql 3.23,

The following method is used:

$ 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

It is always unsuccessful. the mysqldump parameter is also changed, and no suitable one is found.

After several twists and turns, the problem is solved:

You forgot to specify character-set because both sides must 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