[Plugin: WP-DB-Backup] Backup files give error, unable to import (2 posts)

  1. bottleneck
    Posted 6 years ago #

    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', 'contact@xxxxx.com', '', '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.


  2. bottleneck
    Posted 6 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic