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?

Heuristic · 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: 2,031 Thanks: 535 Thanked 255 Times in 193 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?
	[Custom Blog Creation] Want A Site That Makes $300 - $1500 EVERY Month? I'll Build One For You! [HOT NEW PLR!] Get PLR Rights To My Bestselling AUTOPILOT PROFIT FORMULA & Sell It As Your Own! Limited Copies Available

07-17-2009, 12:01 PM	#2
Heuristic HyperActive Warrior War Room Member Join Date: Jan 2008 Posts: 330 Thanks: 73 Thanked 53 Times in 48 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: 3,487 Blog Entries: 6 Thanks: 1,310 Thanked 810 Times in 556 Posts Social Networking Contact Info	Re: Is There A Way To Bulk Delete Spam Comments On Wordpress? Askimet can go one month back.
	Portugal Internet Marketing Since 2004. Fernando Veloso \| Seo Portugal \| Empresa SEO

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: 389 Thanks: 53 Thanked 131 Times in 48 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.
	Click Here To Make $2.63 - $5.93 Per Click As A JV/Affiliate!! Follow Me On Twitter, Facebook ,Visit My Blog

07-17-2009, 12:13 PM	#6
JayXtreme Lookin at You.... War Room Member Join Date: May 2008 Location: Out Of My Mind - Brandy Too Posts: 4,120 Blog Entries: 3 Thanks: 2,885 Thanked 1,344 Times in 710 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
	Bare Murkage.........

07-17-2009, 12:30 PM	#8
Baystreet Active Warrior Join Date: Dec 2008 Posts: 73 Thanks: 0 Thanked 7 Times in 7 Posts	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.