How do I nuke trackback spam safely?

  • I have several hundred trackbacks to delete, and after looking through the admin screens, don’t see any I want to keep enough to sift through individual trackbacks and delete them one by one. What’s the safest way to just nuke them all via SQL?

    I poked around the tables and don’t see anything that’s obviously the right table to empty, and I’d rather not break the working database.

    Please help ??

    Please send me an email at jpb at apesseekingknowledge dot net to let me know you’ve replied to this post, I don’t see how to set my profile to automatically email me if someone replies to a post.

Viewing 4 replies - 1 through 4 (of 4 total)

  • Do you want to delete all trackbacks or just some? If all, then drop this in a PHP file in your WP root and run it:

    <?php

    require('wp-blog-header.php');

    $wpdb->query("DELETE FROM $wpdb->posts WHERE comment_type = 'trackback'");

    ?>

    MAKE SURE TO BACKUP YOUR DATABASE FIRST THOUGH!!!

    Where is your WordPress blog ?
    It’s drupal from your link …
    and we don’t do email support. It takes one click to come back and check on your problem. It takes many more to do emailing.

    WordPress offers bulk moderation. Click Manage, then click Comments, and finally click the “Mass Edit Mode” underneath the search box.

    Now enter into the search box some terms common to the trackbacks you want to nuke. Most likely they’ll have some common terms (poker, viagra, texas holdem, etc) so you can deal with them en masse. Scroll to the bottom of the list, click “Invert Checkboxes”, and then finally click “Delete”.

    Trackbacks all gone.

    ^^ Even better than my method! ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How do I nuke trackback spam safely?’ is closed to new replies.