Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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