move mysql database

最近因換 wordpress hosting的關係,mysql data 從原本的4.121 匯進4.027, 結果中文也都是亂碼.
我發現我從4.121 用 phpmyadmin export 出來的檔案. 只要是中文就已變成亂碼.

這是我在4.121上的setting


character set client utf8
Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir usr/share/mysql/charsets/
collation connection utf8_unicode_ci
(Global value) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci

在4.027上
show variables like ‘%character%’
得到
character_set german1
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis…
convert_character_set

google了兩天, 實在沒什idel. 一是我對database實在不熟,二是google的資料都是從mysql 4.0.x upgrade to 4.1.x, 實在沒人像我這樣版本往下down的.本來想放棄了,必竟花我太多時間了debug. 想就用copy past,慢慢把posts移到新的blog.

Solution:
Use internal wordpress plugin to backup. Finally, chinese post are OK.
In the new blog, install the WP-DBManger plugin to restore.

結果就是感動咧!!!!