PDA

View Full Version : Way to delete ALL comments


mnkyimages
12-12-2008, 10:17 PM
I've done a couple of searches to no avail. My question is simple... after being victim to over 4,000 spam messages I'd just like to delete them all and start over new. However from the admin interface I'm only able to delete 10 at a time. I read something about deleting comments based on keywords but that also didn't work.

So is there a way to delete all comments on a pixelpost blog?

Thank you so much for your help!

snafu
12-13-2008, 01:41 AM
all comments? easy, do it with mysqladmin directly in your mysql database.
search for the datafield named pixelpost_comments and click on the button with the trash bin symbol.

mnkyimages
12-13-2008, 06:53 AM
Thank you very much! I knew there must have been something simple like that. It worked beautifully.

dhdesign
12-13-2008, 06:41 PM
mnkyimages - Did you delete the pixelpost_comments database table itself, or did you just delete all of the comments contained within it?