Dumping and importing from/to MySQL in an UTF-8 safe way
로빈아빠
본문
Do not do this, since it might screw up encoding:
mysqldump -uroot -p database > utf8.dump # this is bad
Better do:
mysqldump -uroot -p database -r utf8.dump
Note that when your MySQL server is not set to UTF-8 you need to do mysqldump --default-character-set=latin
(!) to get a correctly encoded dump.
If you only want to dump the structure without data, use
mysqldump -uroot -p --no-data database -r utf8.dump
Importing a dump safely
Do not do this, since it might screw up encoding:
mysql -u username -p database < dump_file # this is bad
Better do:
mysql -uroot -p --default-character-set=utf8 database
mysql> SOURCE utf8.dump
관련링크
댓글목록
등록된 댓글이 없습니다.