« Google Adwords bans AdultThe Phoenix Forum »
  How to bulk-delete spam comments?
Webmaster Blog
truncate spam
Popular control panels allow one-click removal of spam whithout plugins for Wordpress or other blogs. Very easy to do for everybody.

Blog owners have to fight spam comments all the time. Staying clear of annoying content is easy by disabling comments or by deploying plugins such as Askimet or Spambee. But how can a site administrator delete existing comments all together? You might have underestimated the impact of spam or believed captchas and other plugins would protect you. However, spammers found ways around your protection by injecting fake trackbacks and utilizing cheap captcha solving services using bots for spamming. Suddenly, you are faced with thousands of useless comments. This dead data inflates accounts. It may slow down database performance when reaching critical levels. The question is: How to mass remove spam comment in bulk?
People who use control panels for their hosting have an easy way of purging all comments with one click, basically.

...

No plugins are needed for this at all. When your domain is hosted on a server with a control panel simply login and look for your mySQL databases. In case of popular cPanel solution databases can be administered by phpMyAdmin module. After login as account owner click on phpMyAdmin icon to view your available databases and click on your Wordpress database name which comments you wish to erase. The left hand bar will provide a list of database tables and the main area will show the same list of tables grouped with common commands.
In the next step locate wp_comments table in main frame and click on Empty command. A dialogue will request your confirmation for truncating the contents of this table. Click on OK and all comments on your Wordpress adult blog will be purged. The procedure for b2evo and other self-hosted blogging platforms is pretty much the same.
It's probably best advised to create a working backup before executing database commands to avoid data loss from truncating wrong tables. Better be safe than sorry.

cPanel
Inside hosting control in cpanel look for phpMyAdmin and click to access direct database administration.
Locating wp comments table is easy. One click on empty button and all spam comments and trackbacks are deleted with one simple action.

Feedback awaiting moderation

This post has 1 feedback awaiting moderation...

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)
Contact. ©2017 by Adult Webbie.
International Sex Resources for all