Blog by Andreas Glaser

It happened to me quite a few times now, that I imported a mysql dump file and afterwards noticed that the character encoding was broken.
To help you guys preventing this from happening use following import command.

1

mysql -u root -p --default_character_set utf8 NAME_OF_YOUR_DATABASE < mysql_dump_file.sql

The important argument is “–default_character_set utf8” to preserve the encoding.

Enjoy