MySQL4.0 to MySQL5 migration Data graphics and text tutorial

1. Export the required data table from the MySQL4.0 with phpMyAdmin, and check "zip compression" or "gzip compression" so that the amount of data exported is small.

2. Create a new database in the MySQL5 with phpMyAdmin, note that you need to declare the code as the actual encoding, such as UTF8. If you do not declare the encoding, then cause the import of the data encoding is all latin1, and the Chinese garbled, can not be easily modified.

3. Import the data exported from MySQL4.0 on the Import page, and note that the select character set and SQL compatibility mode are MYSQL40 so that the entire data is successfully imported.

Because of the MySQL default encoding reason, direct import of the entire database can not set its encoding, resulting in Chinese garbled, so the 1th step requires the export of the database table rather than the entire database, to import the entire data need to modify the default MySQL code, modify the installation directory of the My.ini file (Unix is MY.CNF) to the client and server coding declaration, and then restart the service: Default-character-set=utf8