2

We've inherited a WordPress (3.3.2) site that has 13k pending comments, all of which are spam.

To delete all these comments is it sufficient and safe enough to do:

DELETE FROM wp_comments;  
DELETE FROM wp_commentmeta;

...or alternatively TRUNCATE both tables in the database?

2

Yes. That will be sufficient. And I highly recommend that you activate the Akismet plugin to block spam. Probably if you think there might be any genuine comments in the 13k pending ones, then install and activate Akismet first. Then go to Comments in the Wordpress Dashboard, and click on 'Check for Spam'. It should automatically move all spam to the Spam folder.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.