I am exporting a wordpress database using Wp Migrate plugin. The site looks good on production, but when I import the database into my local wordpress site, using local (off course) some spanish characters that are supposed to be shown with an accent, are “broken”, meaning that I see some other characters.
I think this is a collation issue. I am importing the database by going to the Adminer that local provides, droping all the tables, and importing the sql file. When I check the table information, I can already see that the characters are “corrupted” on the database.
production (looks good)
local development with local (accent is “broken”)
mysql database is using utf8_general_ci which I think is fine.
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.