Support » Plugins » [Plugin: WP-DB-Backup] Backup files give error, unable to import

  • Hi, there

    After deleting old unapproved comments
    DELETE FROM wp_comments WHERE comment_approved = 0
    any backup file can’t be imported.
    phpmyadmin reads:

    SQL query:
    INSERT INTO <code>wp_comments</code>
    VALUES ( 8314, 4916, 'jimmie', '', '', '71.61.xx.xx', '2010-03-16 03:44:30', '2010-03-16 01:44:30', 'What do you mean by, My Answer: xxxxxxxxx.', 0, '1', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; AskTB5.2)', '', 0, 0 ) ;
    MySQL said: Documentation
    #1062 - Duplicate entry '8314' for key 'PRIMARY'

    Deleting this particular comment won’t help, it gives an error with another one.
    Sure enough, the classic manual export from phpmyadmin and then importing a file works fine without errors so this issue is truly wp-db-backup plugin bug.

    Tested in different environments on both wp-db-backup plugin 2.2.1 and 2.2.2 versions.

    Any idea for workaround?

    Thanks in advance.

Viewing 1 replies (of 1 total)
  • Another host, another environment. Backup files aren’t usable, all give errors while importing. This time no comments got deleted as in the previous post.

    Beware of that faulty WP-DB-Backup plugin.

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: WP-DB-Backup] Backup files give error, unable to import’ is closed to new replies.