Database Backup Restore Issue

  • blwdjustin

    (@blwdjustin)


    7 years, 9 months ago

    I use automysqlbackup to create backups of the databases of my wordpress sites. However, if I try to restore from backups where your plugin was installed I end up with a few errors like this: Duplicate entry ‘\x0B\xEF\xBF\xBD\xEF\xBF\xBD\xEF\xBF\xBD\xEF\xBF\xBD\xEF\xBF\xBD’ for key ‘PRIMARY’. I can ignore these errors and it will restore everything except for some of your tables like wfKnownFileList and wfFileMod will be blank. Any idea how can I resolve this?

    • This topic was modified 7 years, 9 months ago by blwdjustin.
    • This topic was modified 7 years, 9 months ago by blwdjustin.
Viewing 2 replies - 1 through 2 (of 2 total)
  • wfchar

    (@wfchar)

    7 years, 9 months ago

    Hi @blwdjustin,

    Can you provide more information about your database setup, such as whether you’re using replication and what versions you’re using?

    Thread Starter blwdjustin

    (@blwdjustin)

    7 years, 9 months ago

    No replication. Just a single server with multiple databases on it for different wordpress sites. I’m using mariaDB 10.2.8. I was having issues before with even being able to dump a working .sql file because of the binary being stored in some of the wordfence fields seemed to breaking the encoding. I am using –hex-blog flag now and get a file I can work with and import but with these duplicate entry errors.

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

The topic ‘Database Backup Restore Issue’ is closed to new replies.