What I hadn’t realized was that my old MovableType export included thousands of spam comments…now in this WP blog. I installed SpamKarma 2 but found it still awkward to work through them.

So thanks to Dreamhost’s excellent setup, I was able to fire up phpMyAdmin and connect directly to my blog db and fire off this bit of SQL:

delete FROM `wp_comments` WHERE `comment_ID` > 43

Of course, you should figure out what ID is your last good comment. Or just wipe them all out.

Related posts:

  1. Spam Prevention
  2. Peppered with Spam Comments
  3. Upgraded to MT 2.661 for Spam Protection
  4. Spammer’s delight
  5. Fighting Comment Spam with Captchas