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

  • bottleneck

    (@bottleneck)


    14 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:

    Error
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.

    http://wordpress.org/extend/plugins/wp-db-backup/

Viewing 1 replies (of 1 total)
  • Thread Starter bottleneck

    (@bottleneck)

    14 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.

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