WordPress.org

Ready to get started?Download WordPress

Forums

WP Migrate DB
Encoding fail (11 posts)

  1. Tevashov
    Member
    Posted 1 year ago #

    Hi. I'm trying to export my DB (utf-8) using WP migrate DB and I'm getting file in something like 'Western (Mac OS Roman)' encoding. It's not a problem do convert in to utf, but my website in Russian and contains cyrillic letters. All of them looks like '–ú–∏—Å—Ç–µ—Ä' in an sql dump, produced by WP migrate DB. Everything worked before some update, but now it's broken.

    http://wordpress.org/plugins/wp-migrate-db/

  2. Harish Chouhan
    Member
    Posted 1 year ago #

    Just a guess. Can you try having the charset in your config to utf8 and see if it works?

  3. Tevashov
    Member
    Posted 11 months ago #

    Everything is in utf8.

  4. Standish
    Member
    Posted 11 months ago #

    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,

  5. infoxicated
    Member
    Posted 11 months ago #

    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.

  6. Brad Touesnard
    Member
    Plugin Author

    Posted 11 months ago #

    Can one of you upload your original database to Dropbox, Google Drive, or similar and send me the link at http://bradt.ca/contact/?

  7. infoxicated
    Member
    Posted 11 months ago #

    Will do.

  8. Tevashov
    Member
    Posted 11 months ago #

    Done.

  9. Brad Touesnard
    Member
    Plugin Author

    Posted 11 months ago #

    Thanks, will look into it soon.

  10. Chris Aprea
    Member
    Plugin Author

    Posted 11 months ago #

    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:

    1. Import the original dumps into my local environment
    2. Get the website running (by changing admin password / home & site urls / etc )
    3. Dump the website data via phpMyAdmin ( i.e. dump-1 )
    4. Dump the website data via WPMDB
    5. Import the WPMDB dump into the same installation
    6. 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?

  11. Highfilter
    Member
    Posted 4 weeks ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.