WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Backup contains spurious charactes in posts data (3 posts)

  1. TheAnalyzer
    Member
    Posted 7 years ago #

    MySQL 5.0.15
    phpMyAdmin 2.7.0-pl2

    When I restore a backup of my database, It inserts a load of squiggly characters surrounding certain characters in posts such as apostrophe, hyphen etc. It also adds in the character (A with a dot over it) here and there, for which I can see no pattern. This morning I spent an hour editing the posts in the DB directly!

    Here's an example: r\n\r\nIt’s great to get home
    That should read simply "It's great to get home"

    I restore by pasting the SQL dump directly into the SQL window in PhpMyAdmin as I do not have command line access.

    It may be related to the settings I use in PhpMyAdmin to export the data. I export unzipped and check all of these options as I was advised to by an expert. (it's a new blog)

    Structure
    . Add DROP TABLE
    . Add IF NOT EXISTS
    . Add AUTO_INCREMENT value
    . Enclose table and field names with backquotes

    Data
    . Complete inserts
    . Extended inserts
    . Use delayed inserts
    . Use ignore inserts
    . Use hexadecimal for binary fields

  2. Reaper-X
    Member
    Posted 7 years ago #

    Im using only drop table, if not exists, auto increment, enclose table name, use hexadecimal for structure and only check complete insert and use hexadecimal binary field for data and never experience any problem with it

    btw why did you check complete insert and extended inserts at the same time ? there's no need to use them both

  3. TheAnalyzer
    Member
    Posted 7 years ago #

    Thank you Reaper-X, that has done the job properly.

    Reason I checked everything is because that's what I was told to do by someone who obviously should know better. I have not looked them up to see what their correct usage is. Perhaps I will now.

Topic Closed

This topic has been closed to new replies.

About this Topic