[mysql] mysql dump

mysql db 옮길때 쓰기 위해..

mysql에 접속해서..
mysql> show variables;
해서.. character set 을 확인 후 mysqldump 에 –default-character-set=xxx 에 알맞은 값을 넣어준다.

=========================

mysqldump -u root –password=xxx –add-drop-database –add-drop-table –create-options –default-character-set=latin1 –databases afsguri guri guri0404 guri0517 guri0724 guri1018 hosting_guritower hosting_lll hosting_newtown mysql

mysql -u root -p < guridb_080625_1632.dmp