Backup contains spurious charactes in posts data

  • Resolved theanalyzer

    (@theanalyzer)


    18 years, 6 months 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?￠a??a?￠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

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

  • 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

    Thread Starter theanalyzer

    (@theanalyzer)

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Backup contains spurious charactes in posts data’ is closed to new replies.