Fix Bad Characters â⬠à After Mysqldump and Import Utf-8
Billy Heaton
1 min read
mysqldump --default-character-set=latin1 --opt -h localhost -u
export -p export > export.sql
replace "CHARSET=latin1" "CHARSET=utf8" "SET NAMES latin1" "SET NAMES
utf8" < export.sql > export-utf8.sql
mysql --user=root -p --host=localhost --default-character-set=utf8
cms_production < export-utf8.sql