Best way to delete 12,000 wordpress comments?

[Kard63]

What is the best way to delete these fuckers?


I know some ignorant trolls will give me ways to prevent it from happening in the first place instead of answering my question but thanks in advance to anyone who actually helps.

[Machete_]

get someone that know mysql to write you a dump to phpmyadmin.

Copy-Paste-Execute-Done

[Sosa]

I'd suggest phpmyadmin as well

[Libertine]

get someone that know mysql to write you a dump to phpmyadmin.

Copy-Paste-Execute-Done

This. Shouldn't take more than 5 minutes, and that includes making a cup of coffee and drinking it.

[Antonio]

phpmyadmin - export your database as sql file to your HD, keep one back up copy
open the sql file in a text editor
find table wp_comments
delete all comments
import database back using phpmyadmin

[Antonio]

you can execute SQL quiery directly in phpmyadmin, but the chances of you fucking up are much hgher ;)

[tranza]

I'm bookmarking this thread for future reference.

[V_RocKs]

Do they follow a pattern?

[kowalsky]

yeah, I had to deal with that shit a few weeks ago. Then I asked my server admin to do it on the DB.

[GrouchyAdmin]

delete from wp_comments where 1=1;

all done.

[georgeyw]

What is the best way to delete these fuckers?


I know some ignorant trolls will give me ways to prevent it from happening in the first place instead of answering my question but thanks in advance to anyone who actually helps.

I'm guessing you don't know anything about mysql - if you have phpmyadmin, login to the db, select the table and top right is an 'empty' link. Click that and your comments table will be free of spam (and ALL other comments).

[darksoul]

delete from wp_comments where 1=1;

delete from wp_comments where comment_approved=0;

[CaptainWolfy]

spam karma... plugin for wp

[TheDoc]

Upgrade your Wordpress to current, click the spam count # on the dashboard. Click the "Delete All Spam" button.

It's built straight into the new wp..