Weird characters after mysqldump export and import on new server

Hold on Cowboy

This blog post is pretty old. Be careful with the information you find in here. It's likely dead, dying, or wildly inaccurate.

The other day I had to migrate a Wordpress database from one server to the other. I used mysqldump to export the SQL and data from the old server.

Then I used this to import mysql -uusername -ppassword database < backup.sql

This went fine, but I found I was seeing weird characters in the front end and through phpmysqladmin. The “Collation” on both tables seemed the same.

Then I stumbled on a website that offered this change when importing

mysql -uusername -ppassword --default-character-set=utf8 database < backup.sql

That fixed my troubles… now on to more important things.

Did this help you out? It took me a few days to piece together all this information together, I hope this saves you some time (who knows, maybe the future me will be thankful I wrote this down). Let me know your thoughts. [email protected]