Database backup/restore

  • Resolved adeco2

    (@adeco2)


    19 years, 8 months ago

    Backed up my database, but when restoring the site can barely be read. It’s written in a foreign language. I tracked the problem down to differences between the database (accessed though phpmyadmin.powweb.com) and the back up file.

    Database on line says: ” contradicci???3 “
    Backup file reads: ” contradicci???’???3 “
    Or ” per???2 ” vs. ” per???’???2 ”

    When restoring the website reads ” per???2 “

    I’m told that I need to convert the backup file to a different format. Like utf-8, but I don’t know how to do it, nor I have the appropriate tools. What’s more, I don’t know why I need to convert the file. Wouldn’t it be better if the file was ok in the first place, or even the database (don’t understand why it’s stored that way).

    Can you help me with this?

Viewing 4 replies - 1 through 4 (of 4 total)

  • This database problem – there are a few threads – is resolved.

    Solved by using Notepad++, utf-8 and a lot of copy/paste.

    IF your WP tables store entries in utf-8 (most likely), you need to make sure to set an appropriate utf-8 character set and language when you log in to phpMyAdmin (the language drop down field on the login screen) before exporting the database, so phpMyAdmin knows about the right character set.

    If the character sets of WP and phpMyAdmin don’t match, the special characters get distorted by an export.

    Which character set WP uses can be seen under Options/Reading/Encoding for pages and feeds

    I don’t know if you can convert your sql file back to utf-8, but you can try to do it using a text editor that has this capability. I don’t know of one on Windows, on Linux you can use Bluefish for that.

    Character sets are a bit confusing, I hope I could help you anyway.

    Sanne

    Ah, didn’t see your post, podz. Sorry to have rambled on, I’m glad it’s resolved ??

    Sanne

    Ain’t getting no satisfaction on this elsewhere – and this is a different angle on it, so…

    I’m running 1.5.1.2 and still having encoding issues on database restores. I’ve tested with Notebook++ and other text editors/converters, and all with the same results – on restore – but when pasting into WP before backing up characters are all still fine.

    Does anyone know the details of the problem and the fix – after months (okay part-time) this still eludes me. Is it still necessary to use a command-line sql restore with the iconv filter to convert to UTF8 even after this fix? If so, what are the characters in the database that will need this extra attention?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database backup/restore’ is closed to new replies.

Tags