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

About the Author

Billy Heaton
Billy Heaton

Software engineer with two decades of experience who favors Ruby and JavaScript to build web applications