Using phpMyAdmin to migrate WordPress data from MySQL4 to MySQL5

By comparing the different points of the WordPress data with phpMyAdmin from MySQL and MySQL5 to solve the problem in migration, this solution is not only used in migrating WordPress data, but is actually generic.

Using phpMyAdmin (Mysql&phpmyadmin installed in win) in MySQL4 Select database "Export" The required WordPress data, such as the figure Select "Save as File" so you get a suffix for. SQL export file is saved on the local machine.

Open MySQL5 with phpMyAdmin, as shown by default to create a new database.

Import the required data in the "import", such as the figure, the successful configuration of the database link file, that is, you can browse.

Note that the file character set must be selected Latin1, which is the default when the MySQL database is created.

The maximum size of the import file in the above image is 2048k, which is received php.ini file control and can be changed by modifying Upload_max_filesize,memory_limit and Post_max_size.

But this is not a problem to use, but if you use phpMyAdmin to look at the database table, you will find that the Chinese are all garbled, that is, the above file is the character set is a latin1 problem.

In fact, when you export data, if you do not select "Save As File", you will export a section of SQL statements, if you put this statement directly in the phpMyAdmin execution, you will appear as a figure error: