show variables like "%character%";
show variables like "%collation%";
my.cnf
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
skip-character-set-client-handshake
character-set-server=utf8
collation-server=utf8_general_ci
init-connect=SET NAMES utf8
port=3306
socket=/tmp/mysql.sock
Latin1 to UTF8
mysqldump -u root -p --default-character-set=latin1 [db] > db.sql
open & edit db.sql change
/*!40101 SET NAMES latin1 */;
to
/*!40101 SET NAMES utf8 */;
and import db.sql to MySQL
mysql -u root -p --default-character-set=utf8 < db.sql
done!
