After deleting old unapproved comments
DELETE FROM wp_comments WHERE comment_approved = 0
any backup file can't be imported.
Error SQL query: INSERT INTO <code>wp_comments</code> VALUES ( 8314, 4916, 'jimmie', 'firstname.lastname@example.org', '', '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.