flagflag  
1: 2008-12-24 (Wed) 00:49:50 iseki source 2: 2008-12-24 (Wed) 03:28:48 admin source
Line 2: Line 2:
*** データベースの移行 [#k88ea100] *** データベースの移行 [#k88ea100]
 +- 移行元のデータベースの CHARSETが latin1 で EUCで保存
 +- 移行先は utf8
 + % mysqldump source_db source_table --default-character-set=latin1 -x -u root -p > table_data
 + % nkf -w table_data > table_data.utf8
 +テーブル名,CHARSETを新しいデータベースに合わせる.
 + % mysql dist_db -u root -p < table_data.utf8


Front page   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthMay 2024Next Month
Su Mo Tu We Th Fr Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Today

Who's Online

95 user(s) are online (28 user(s) are browsing xpwiki)

Members: 0
Guests: 95

more...

Access Counter

Today : 2074207420742074
Yesterday : 1033710337103371033710337
Total : 2360194423601944236019442360194423601944236019442360194423601944
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com