MySQL 4.0 to MySQL 4.1

Even in Win2000, MySQL 4 databases are always worried about upgrading to 4. 1. If there is a problem, phpMyAdmin 2 is used. 7. Export and import the data
MySQL 4. 1, Chinese characters are garbled, so I had to put MySQL 4.1. Change the INI encoding to gb2312, and change
All database files are copied directly to 4. The result is not garbled in the data directory of 1.

Of course, a better method is to use mysqldump, such
Mysqldump-u xxx-p xxx -- default-character-set = utf8 test_db> C: \ test. SQL. UTF-8 is used for export,
For MySQL 4. 1 export to MySQL 4, then
Mysqldump-u xxx-p xxx -- compatible = mysql40 -- default-character-set = utf8 test_db> C: \ test. SQL

The import process is simple. use MySQL commands, such
Mysql-u root-P 123456 test_db <c: \ test. SQL