[ MySQL ] - 명령어

 = mysqldump : 분할 덤프

  > mysqldump -u designok -p designok | split -b 200m - designokSplit.sql

# mysql character set latin1

mysql>mysql dump -uroot -p --default-character-set=latin1 --set-charset [db name] > backup.sql
mysql>mysql -uroot -p --default-character-set=utf8 [db name] < backup.sql

# mysql character set euckr

mysql > mysql dump -uroot -p --default-character-set=euckr --set-charset [db name] > backup.sql
mysql >mysql -uroot -p --default-character-set=utf8 [db name] < backup.sql



vi편집기 일괄 치환
:%s/찾을문자열/바꿀문자열/g