Converting MySQL from latin1 to utf8
Edit /etc/mysql /my.cnf Under [client] add
1 |
default-character-set = utf8 |
Under [mysqld] add
1 2 |
collation_server = utf8_general_ci character-set-server = utf8 |
Dump you database to a file
1 2 3 |
mysqldump -u USERNAME -pDB_PASSWORD --opt --skip-set-charset --default-character-set=latin1 --skip-extended-insert DATABASENAME --tables TABLENAME > DUMP_FILE_TABLE.sql |
Then edit your dump file and change every CHARSET=latin1 Read More