To convert the existing DB from euc-kr to utf8, after carefully (??) backing it up,
I opened it in editplus, and it says it contains characters that may be lost in the current encoding,
I ignored it, changed it to UTF8, and imported …. Damn ㅠㅠ It won’t work because of the corrupted characters
I searched frantically~~~~ but couldn’t find a solution in the end..
(What do you do in cases like this, where it still doesn’t work even after specifying all the options, including —default-character-set, when dumping? ㅠㅠ)
With no other choice, I found the source below and modified it to suit my needs (UTF8 conversion, selecting the tables I wanted)
Migration confirmed!!!! — Migrating is as annoying and tiring as ever ㅠㅠ
[PHP]
0)
{
$backText = »
# MysqlDump
# Host: «.$mysql_host.»
# Processed at: «.date(‘Y-m-d H:i’).»
# Server version: «.mysql_get_server_info().»
# Database: `».$mysql_db.»`
# ———————————————————nnnnn»;
while($rows = mysql_fetch_row($tables[0]))
{
$chk = false;
for($i=0;$i
[/PHP]
