Is There A Way To Bulk Delete Spam Comments On Wordpress?

Hamida Harland · 07-17-2009, 11:14 AM

I just logged in to one of my wordpress blogs that I hadn't checked in a while and it's got over 1000 spam comments

(my own fault as I forgot to activate Akismet). Is there any way to bulk delete the comments or do I have to do it page by page?

steve39 · 07-17-2009, 12:01 PM

I had a similar experience a while back. Had a blog without Akismet and neglected it for months. I never thought spam would be a problem because it had little traffic to begin with. Lo and behold, I opened my admin one day and found thousands of spam comments. I deleted them a page at a time. So, while there may be a way to mass delete, I didn't find it. Those spammers create more work for me than you can imagine...

Fernando Veloso · 07-17-2009, 12:03 PM

Askimet can go one month back.

Sudar · 07-17-2009, 12:06 PM

If the comments are in the moderation queue, then you can activate Akismet and click "Check for spam" button. Once all of them are identified as spam, you can delete all of them by clicking the "Delete all spam" button.

Devon Brown · 07-17-2009, 12:09 PM

There should be a little check-mark button up at the top that will allow you to "select all" and you can delete in bulk from there.

Otherwise, take the others advice and see if Akismet can go back into time.

JayXtreme · 07-17-2009, 12:13 PM

Hamida...

You can do this in phpMyAdmin with a simple line of code..

Log in to phpMyAdmin

Select the relevant WordPress database

Hit the SQL Tab

And type in the following command:

delete from wp_comments where comment_approved = '0'

^ (Copy and paste from here to ensure accuracy) ^

This will remove all unapproved comments in a millisecond!

Peace

Jay

Hamida Harland · 07-17-2009, 12:17 PM

Quote:

Originally Posted by JayXtreme

Hamida...

You can do this in phpMyAdmin with a simple line of code..

Log in to phpMyAdmin

Select the relevant WordPress database

Hit the SQL Tab

And type in the following command:

delete from wp_comments where comment_approved = '0'

^ (Copy and paste from here to ensure accuracy) ^

This will remove all unapproved comments in a millisecond!

Peace

Jay

That's exactly what I was looking for

. Thanks Jay.

Baystreet · 07-17-2009, 12:30 PM

If you don't want to go the phpMyAdmin route you can use a plugin call WordPress Suicide

http://justinsomnia.org/2006/04/wordpress-suicide/

I just deleted over 97,000 comments on a blog that I have not looked at in three years.

07-17-2009, 11:14 AM	#1
Hamida Harland Senior Warrior Member War Room Member Join Date: Feb 2007 Location: UK Posts: 1,394 Thanks: 215 Thanked 111 Times in 80 Posts	Is There A Way To Bulk Delete Spam Comments On Wordpress? I just logged in to one of my wordpress blogs that I hadn't checked in a while and it's got over 1000 spam comments (my own fault as I forgot to activate Akismet). Is there any way to bulk delete the comments or do I have to do it page by page?

07-17-2009, 12:01 PM	#2
steve39 HyperActive Warrior War Room Member Join Date: Jan 2008 Location: Toronto, Canada Posts: 161 Thanks: 28 Thanked 26 Times in 24 Posts	Re: Is There A Way To Bulk Delete Spam Comments On Wordpress? I had a similar experience a while back. Had a blog without Akismet and neglected it for months. I never thought spam would be a problem because it had little traffic to begin with. Lo and behold, I opened my admin one day and found thousands of spam comments. I deleted them a page at a time. So, while there may be a way to mass delete, I didn't find it. Those spammers create more work for me than you can imagine...

07-17-2009, 12:03 PM	#3
Fernando Veloso Portuguese Warrior War Room Member Join Date: Nov 2008 Location: Good Old Europe Posts: 1,094 Blog Entries: 1 Thanks: 348 Thanked 131 Times in 93 Posts Social Networking	Re: Is There A Way To Bulk Delete Spam Comments On Wordpress? Askimet can go one month back.
	*Discover MiniSiteBox -- Yes, You get Professional Minisites... but you don't have to spend what others* charge you for a "I've seen it before!!" sales page.** We just do our stuff from scratch. You just sit and cash in.

07-17-2009, 12:06 PM	#4
Sudar WordPress Developer Join Date: Mar 2009 Location: Chennai, India Posts: 2 Thanks: 0 Thanked 1 Time in 1 Post Social Networking	Re: Is There A Way To Bulk Delete Spam Comments On Wordpress? If the comments are in the moderation queue, then you can activate Akismet and click "Check for spam" button. Once all of them are identified as spam, you can delete all of them by clicking the "Delete all spam" button.

07-17-2009, 12:09 PM	#5
Devon Brown Renegade Warrior War Room Member Join Date: Feb 2009 Location: Atlanta, GA Posts: 257 Thanks: 28 Thanked 59 Times in 23 Posts Social Networking	Re: Is There A Way To Bulk Delete Spam Comments On Wordpress? There should be a little check-mark button up at the top that will allow you to "select all" and you can delete in bulk from there. Otherwise, take the others advice and see if Akismet can go back into time.
	Follow Me On Twitter or Facebook and Discover My Viral Twitter Software +++WSO+++ Or Feel Free To Visit My Blog or Better Yet, My Youtube Channel

07-17-2009, 12:13 PM	#6
JayXtreme Babyfaced Assassin War Room Member Join Date: May 2008 Location: Out Of My Mind - Brandy Too Posts: 3,275 Blog Entries: 5 Thanks: 1,658 Thanked 817 Times in 436 Posts Social Networking	Re: Is There A Way To Bulk Delete Spam Comments On Wordpress? Hamida... You can do this in phpMyAdmin with a simple line of code.. Log in to phpMyAdmin Select the relevant WordPress database Hit the SQL Tab And type in the following command: delete from wp_comments where comment_approved = '0' ^ (Copy and paste from here to ensure accuracy) ^ This will remove all unapproved comments in a millisecond! Peace Jay
	Twitter Me Alls I Need Is: 5 Lines Of Text And A BUYNOW Button To Sell Sh1t!... Eyeballs To Offers.... You Need Traffic!..

07-17-2009, 12:30 PM	#8
Baystreet Active Warrior Join Date: Dec 2008 Posts: 47 Thanks: 0 Thanked 1 Time in 1 Post	Re: Is There A Way To Bulk Delete Spam Comments On Wordpress? If you don't want to go the phpMyAdmin route you can use a plugin call WordPress Suicide http://justinsomnia.org/2006/04/wordpress-suicide/ I just deleted over 97,000 comments on a blog that I have not looked at in three years.