Mass delete spam in WordPress

Posted by LogoBlogger
March 10, 2009

Man, what a hassle. You leave your blog unattended for a couple of months and kablam, thousands of spam comments that you have to delete page by page. Surely there must be some way to just delete them all in one go? A super delete button somewhere. That’s the only way us humans can defeat the super spam robots.

Well, no super delete button, but there is a way to mass delete comments through phpMyAdmin. Be sure to make a backup of your database before you do.

Detailed instructions here:

http://wordpress.org/support/topic/176407

Share this: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • Netvouz
  • DZone
  • ThisNext
  • MisterWong
  • Wists
Other Rants

If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.

Comments
Comment by Geoff on April 1, 2009 @ 2:56 pm

Hope this works, 16 374 messages gonna take a long time to delete manually

Comment by LogoBlogger on April 13, 2009 @ 8:49 pm

Geoff, I tried it and it worked great for me. But keep in mind: This is the kitchen sink method - you’ll be deleting the good comments with the spam.

Comment by JessicaJax on May 10, 2009 @ 2:59 pm

Your site displays incorrectly in Firefox, but content excellent! Thank you for your wise words:)

Comment by LogoBlogger on May 10, 2009 @ 10:47 pm

Thanks for the heads-up Jessica. It looks even worse in IE! :D
Can’t seem to get my brain around this darn template and CSS thing. Why can’t we all just build plain HTML in notepad like we used to..

Trackback by WILLIAM on September 7, 2010 @ 3:15 am


CheapTabletsOnline.com. Canadian Health&Care.Special Internet Prices.Best quality drugs.No prescription online pharmacy. High quality pills. Buy pills online…

Buy:Viagra Soft Tabs.Viagra Super Active+.Zithromax.VPXL.Viagra Super Force.Propecia.Cialis.Maxaman.Viagra Professional.Cialis Professional.Soma.Cialis Soft Tabs.Viagra.Tramadol.Cialis Super Active+.Super Active ED Pack.Levitra….

Leave a comment

(required)

(required)