轉移資料進度達95%

昨天一整個晚上在弄BLOG資料轉移,發現只要一把資料庫匯入到新的主機就會發生BLOG都是????的慘烈情況,經過我上網查詢發現是MYSQL版本不一樣的關係,之前我在舊的主機版本是4.0X目前新的dreamhost還有一些國外的主機商他們都升級到4.1X,很多人升級過後都會發生問題。

在跟主機商信件往來還有剛好去查詢SMF的資料時發現他們匯入資料庫時編碼好像要選擇Latin1而不是原本習慣的UTF-8,至於為什麼?因為我不是相關科系原因不知到,不過道士讓我成功把資料庫轉移到新的主機,所以就把經驗寫下來說不定給改天用得到。
SMF的那一篇文章
google找到的資料

主機商的回信
It appears that your mysql backup file is in UTF-8 encoding, it is
likely that the mysql client is connecting using the Latin-1 character
set. You will need to set phpMyAdmin or the `mysql` command line client
to UTF-8. If you need further help please let us know, we also currently
do not have mbstring installed with php so phpmyadmin may prove difficult
to use.

Thanks!

Kelly

One Reply to “轉移資料進度達95%”

  1. Pingback: 精神奕奕

Leave a Reply

Your email address will not be published. Required fields are marked *