[Mysql] mysql자료 utf8로 conversion

[DB덤프]
mysqldump -u{username} -p{password} {dbname} --default-character-set latin1(or euckr등 상황에 맞춰서) > {dump}.sql

[DB덤프 UTF8로 바꾸기]
# vi {dump}.sql
SET NAMES latin1; (or euckr;) 부분을 SET NAMES utf8; 로 변경.
:1,$s/CHARSET=latin1(or eurkr)/CHARSET=utf8/g
(CREATE DATABASE ..... DEFAULT CHARSET=latin1 으로 된 부분을 utf8로 일괄수정. vim에서)

[DB생성]
CREATE DATABASE {utf8-dbname} DEFAULT CHARACTER SET utf8;

[DB복구]
mysql -u{username} -p{password} {utf8-dbname} < {dump}.sql

[my.cnf 설정]
[client]
default-character-set=utf8
[mysqld]
init_connect=SET collation_connection=utf8_general_ci
init_connect=SET NAMES utf8
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci