Knowledgebase

Well the best way is to manage your wordpress comments daily and delete them as they appear. If you have let the comment spam pile up (easily done) then it can be difficult to delete from wordpress admin as it takes too long to load. The other downside to having all this usless data in your db is that it slows the server and your site down.

Ok here is how we remove it:

*please ensure you backup your database before running these commands.*

1: Login to cpanel http://yourdomain.com/cpanel.

2: open phpmyadmin and select your wordpress db on the left menu

Tutorial on how to use phpmyadmin here:

http://simplybehosted.co.uk/billing/demos/cpanel-x3/cpanel-x3-phpmyadmin.html

3: click on the wp_comments table on the left.

4. click on the sql tab at the top of the page. A box will appear titled 'Run SQL query/queries on database' with a default value of:

SELECT * FROM `wp_comments` WHERE 1

remove this text and paste in this text in it's place:

DELETE FROM `wp_comments` WHERE `comment_approved`='0'

and click the go button.

This will remove any comments you have not approved. This will free up disk space and reduce the server load making your site faster to load. Now all you have to do is try and keep on top of the spammers :)

Add to Favourites

Print this Article