11 {{ upvoteCount | shortNum }}
11 {{ upvoteCount | shortNum }}

Deleting massive amounts of spam comments

by pvijeh
8 replies
Has anyone figured out an easy way to delete a massive amount of spam comments that you warriors are probably responsible for

One of my sites has been overrun by spam comments and I want to get rid of them somehow.
#amounts #comments #deleting #massive #spam
  • Profile picture of the author PotPieGirl
    This plugin has worked wonders for that for me...

    WordPress › WP-Optimize « WordPress Plugins

    I haven't installed it in a while tho - but it worked great to purge the spam comments and clean up databases and all that. Easy too - just click a button inside your wp-admin dashboard and give it a moment to do it's thing.

    Jennifer
    ~PotPieGirl
    Signature

    These 15 simple tips worked wonders for my Amazon affiliate earnings =)
    {{ DiscussionBoard.errors[8307494].message }}
  • Profile picture of the author JonBird
    Hi pvijeh,

    I have used this Mass Comment Removal tool in the past on some of my sites and it worked like a charm.

    WordPress › Support » Bulk Comment Remove

    If you have access to the backend... you can also go directly in the phpmyadmin and remove the comments from there. Here's the breakdown to do it that way.
    1. Go to phpmyadmin
    2. Choose your database from the left: wrdp1 for example.
    3. You will see wp_comments in the main page.
    4. Follow that along and select empty.
    All comments will now be gone.

    Make sure you backup your wordpress site before messing around with the plugin or phpmyadmin... just in case.

    Hope this helps.
    {{ DiscussionBoard.errors[8307536].message }}
  • Profile picture of the author sbucciarel
    Banned
    Go to your cpanel and then to phpMyadmin
    Click on your database
    Run this query
    DELETE FROM wp_comments WHERE comment_approved = 1
    If you want to delete all the comments, also run this
    DELETE FROM wp_comments WHERE comment_approved = 0

    They will be instantly deleted.
    {{ DiscussionBoard.errors[8308882].message }}
  • Profile picture of the author competent123
    10+ WordPress comment management plugins | Webdesigner Depot

    although not directly related to your question, but you may wish to see these plugins as well, it might make your life easier.
    Signature
    {{ DiscussionBoard.errors[8308938].message }}
  • Profile picture of the author pvijeh
    I agree- i HATE comments. i have since disabled them on all of my sites, but still need to take out the trash.
    {{ DiscussionBoard.errors[8312126].message }}
  • Profile picture of the author pvijeh
    thanks all for the excellent responses - i will check them out and see what i can get to work!
    {{ DiscussionBoard.errors[8312131].message }}
  • Profile picture of the author joseph7384
    Originally Posted by pvijeh View Post

    Has anyone figured out an easy way to delete a massive amount of spam comments that you warriors are probably responsible for

    How can you make such a blanket statement?:rolleyes:

    Never mind I just caught the wink.
    Signature
    {{ DiscussionBoard.errors[8312232].message }}

Trending Topics