Just a guess. Can you try having the charset in your config to utf8 and see if it works?
Same problem here. Been using this script for many sites and had no problem with this. Everything is in UTF8 also. This is one of the “rare” website that is not using WPML (yet) and is only in English (for now).
Thanks for the great plugin though,
Was there ever a resolution for this?
I’m getting similar issues with weird characters appearing in the dumped text. The db collation is UTF8_unicode_ci.
Can one of you upload your original database to Dropbox, Google Drive, or similar and send me the link at http://bradt.ca/contact/?
Thanks, will look into it soon.
Hey Guys,
I work with Brad on WP Migrate DB and thought I’d chime in here to try to figure out what might be happening.
Brad has provided me with a few of the dumps that you guys have provided for testing purposes. This is what I’ve tried so far:
- Import the original dumps into my local environment
- Get the website running (by changing admin password / home & site urls / etc )
- Dump the website data via phpMyAdmin ( i.e. dump-1 )
- Dump the website data via WPMDB
- Import the WPMDB dump into the same installation
- Dump the website data via phpMyAdmin ( i.e. dump-2 )
I then ran a diff tool across the phpMyAdmin dumps dump-1 and dump-2. Unfortunately they appear to be identical. So WPMDB appears to be doing it’s job in that the data is exactly the same before and after the import.
It sounds like you guys are seeing odd characters in the dumps but is this actually affecting the content at all? That is, are you seeing weird characters on the front end of the website when you import the WPMDB dumps?
Getting the same issue. Exported the DB from a live WP install and brought it down to a local environment and seeing encoding errors on the front-end of the site. When I check the actual DB dump file as well, I can see the weird encoding errors.
Stuff like:
Today's
Will appear like:
Today’s
Any help would be appreciated.