DQ NO.1 - dragon quest fans club

 找回密碼
 加入成為夥伴
搜索
熱搜: 活動 交友 discuz
查看: 3876|回復: 1

[其它] 佬舊MYSQL4.0轉移MYSQL5(UNICODE)

[複製鏈接]
發表於 2006-9-10 17:45:39 | 顯示全部樓層 |閱讀模式
first,use mysqldump to dump database -->database.sql

mysqldump -uroot -p databasename >database.sql


second,convert your database.sql to UNICODE

USING ConvertZ with an usful LIST to solve MR."許功蓋"
(if you are using Windows)

you can get a new file(database-utf8.sql) that encoding by utf8

finally~ restore it to your new database!

mysql -uroot -p --default-character-set=utf8 databasename < database-utf8.sql

 樓主| 發表於 2006-9-10 19:11:37 | 顯示全部樓層
phpBB升級UNICODE

before start,plz make sure you have "convertZ".

first,convert all language(.php) file to utf-8
and replace the "big5" to "utf-8" in all language file

then,open this file"./include/db.php"
add this

$db-&gt;sql_query("SET NAMES utf8;");
$db-&gt;sql_query("SET CHARACTER_SET_CLIENT=utf8;");
$db-&gt;sql_query("SET CHARACTER_SET_RESULTS=utf8;");

before " ?&gt; "

finish!
回復 支持 反對

使用道具 舉報

您需要登錄後才可以回帖 登錄 | 加入成為夥伴

本版積分規則

Archiver|手機版|ぱふぱふ屋|DQ NO.1

GMT+8, 2024-3-29 22:45 , Processed in 0.022493 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回復 返回頂部 返回列表