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]