Dumping and importing from/to MySQL in an UTF-8 safe way
In a nutshell: to avoid your shell character set from messing with imports, use
-r
to export and SOURCE
when importing.Dumping safely
Better do:
Note that when your MySQL server is not set to UTF-8 you need to do
mysqldump --default-character-set=latin1
(!) to get a correctly encoded dump. In that case you will also need to remove the SET NAMES='latin1'
comment at the top of the dump, so the target machine won't change its UTF-8 charset when sourcing.
If you only want to dump the structure without data, use
Importing a dump safely
Better do:
Không có nhận xét nào:
Đăng nhận xét