Mysql Dump

> Mysql 내부 명령어

LOAD DATA INFILE '/Users/jackkim/Desktop/ijji migration/db dump/t_codemst.csv'

INTO TABLE ijji_codemst 

FIELDS TERMINATED BY ',' 

LINES TERMINATED BY '\n' 

(kind,code,regdt,username,manname,memo,useflag);

Ref: http://dev.mysql.com/doc/refman/5.0/en/load-data.html

Note: Delimiter를 지정할 수 있음, dump전에 기존데이타 삭제 기능은 작동안하는듯..

> Mysql 외부명령어

mysqlimport5 -u userid -p 디비명 파일명

Ref: http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html

Note: Tab Delimiter외에는 허용하지 않는것 같음, 기존 데이타 삭제 가능

> Dump과정에서 발생하는 Warinig, Error메세지 확인

show warnings;

show errors;

Ref: http://blog.naver.com/sjpotato?Redirect=Log&logNo=40120878703

> Charset변경

Mysql Default Characterset: my.cnf

[client] ... .... ...

default-character-set=utf8 ....

and further down in my.cnf

[mysqld] ... ...

default-character-set=utf8

default-collation=utf8_unicode_ci

character-set-server=utf8

collation-server=utf8_unicode_ci

... ...

Mysql Database Charset변경

ALTER DATABASE mydatabasename charset=utf8;

Source File의 Charset변경(Linux기준)

vim dump-fixed.sql
:%s/DEFAULT CHARACTER SET latin1/DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci/
:%s/DEFAULT CHARSET=latin1/DEFAULT CHARSET=utf8/
:wq

Ref: http://docs.moodle.org/22/en/Converting_your_MySQL_database_to_UTF8