Проблемы с кодировкой в MySQL

Узнаём в какой кодировке хранятся данные:

mysql -u root -e 'show create database `dbname`'
+------------------------------------------------------------------+
| Create Database                                                  |
+------------------------------------------------------------------+
| CREATE DATABASE `itvault` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+------------------------------------------------------------------+

Делаем дамп:

mysqldump -u root --default-character-set=utf8 dbname > dump.sql

Узнаём в какой кодировке работает mysql-клиент на сервере назначения:

mysql -u root -e "show variables like '%char%'"
+--------------------------+----------------------------------+
| Variable_name            | Value                            |
+--------------------------+----------------------------------+
| character_set_client     | latin1                           |
| character_set_connection | latin1                           |
| character_set_database   | utf8                             |
| character_set_filesystem | binary                           |
| character_set_results    | latin1                           |
| character_set_server     | utf8                             |
| character_set_system     | utf8                             |
| character_sets_dir       | /usr/local/share/mysql/charsets/ |
+--------------------------+----------------------------------+

Заливаем дамп в правильной кодировке:

mysql -u root --default-character-set=latin1 dbname < dump.sql