Movable Type Community Forum > Deleting comments wholesale in v2.661

Full Version: Deleting comments wholesale in v2.661

Movable Type Community Forum > Using Movable Type > Commenting System

stonneway

Mar 3 2005, 07:14 AM

Is there anyway to remove all comments from all blogs in v2.661 ?

WE have been struck by comment spam, and have about 10,000 emails across four blogs.

I have spent a day ticking and deleting and havent made an indent.

Any ideas ?

S

imabug

Mar 3 2005, 07:24 AM

what database are you using? If you're using an SQL database, then a simple

CODE

DELETE FROM mt_comment

will do the trick for you.

if you are using BerkeleyDB, then you'll have to write yourself a script to do the job.

kymberlie

Mar 3 2005, 07:25 AM

I don't really have any ideas for you, but this is the reason that I finally upgraded to 3.15 after putting it off for so long.

The upgrade process was pretty easy, so you might want to consider biting the bullet and giving it ago.

Hopefully someone else might have an idea for you.

Kymberlie

DavidInnes

Mar 3 2005, 11:47 AM

Wait a second! If I have MySQL admin access can I really delete 98% of my comment-spam backlog from within MySQL?

For instance:

CODE

DELETE FROM mt_comment WHERE comment_author LIKE '%poker%'

or even (once you've approved everything you want to keep) something like:

CODE

DELETE FROM mt_comment WHERE comment_visible IS NULL

Is that all there is to it or will that break dependencies elsewhere?

Thanks,

-- David Innes

imabug

Mar 3 2005, 01:11 PM

QUOTE (DavidInnes @ Mar 3 2005, 02:47 PM)

Wait a second! If I have MySQL admin access can I really delete 98% of my comment-spam backlog from within MySQL?

[snip]

Is that all there is to it or will that break dependencies elsewhere?

Thanks,

-- David Innes

yes, you can do this. it's pretty safe. the only thing you risk is losing legitimate comments.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.