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]