WordPress.org

1. imsoper
   Member
   Posted 2 years ago #

   I'm working on a client's blog that currently has 9,900 comments pending (most, obviously are spam). I've installed Akismet and want to somehow automatically irradicate the spam comments. I tried to use "Check for Spam" button, but that doesn't do anything, it takes me to a blank screen.

   Does anyone know a way of automatically going through a LARGE number of comments and mark them as spam?

2. Samuel B
   moderator
   Posted 2 years ago #

   a fairly quick way to do it
   download this plugin
   http://wordpress.org/extend/plugins/wp-db-backup/
   install it and do a database back up with it
   choose the option to exclude spam comments
   download the back up

   now import the backup
   http://codex.wordpress.org/Restoring_Your_Database_From_Backup
   spam gone

3. Shane G.
   Member
   Posted 2 years ago #

   Hi,

   YOu can execute this query to delete all spam comments at once:

   delete from wp_comments where comment_approved = ’spam’;

   Thanks,

   Shane G.

Topic Closed

This topic has been closed to new replies.