[HOW TO] Dumping and importing from/to MySQL in an UTF-8 safe way

to avoid your shell character set from messing with imports, use -r to export and SOURCE when importing.

Export: mysqldump -uroot -p database -r utf8.dump

Import: mysql -uroot -p --default-character-set=utf8 database
mysql> SET names='utf8'
mysql> SOURCE utf8.dump

 Thank you for reading this article, please a comment if you are interested.

Tiến Phan - R0039

Knowledge is Endless

Sharing for Success