Comment spammers blasted away in one foul swoop

I just checked out my http://cheapflightscruises.com/traveltalk blog which as the name suggests is a travel blog after not logging on for a while and discovered I had 21200 comments awaiting moderation. Crazy!! All spammers.

I decided to google how to bulk remove comments from WordPress and came across a helpful article that showed me how.

It took one minute and blew them all away with just one SQL command in PHPmyadmin.

DELETE FROM wp_comments WHERE comment_approved ='0' is all it took after going into the wordpress database that had all the comments.

Obviously the spammers think they get some value from what they do as some people would have auto-approve comments but not on my blog.

 

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s