Monday, December 30, 2013

Deleting WordPress comments on the go!

Just sharing the useful information on blogging with wordpress. If you are one of those bloggers with wordpress and fed up of deleting the SPAM in the comments and if you are looking for something to wipe up complete comments which has no approval then, you should be reading this article.
What you need?
- A wordpress blog. Dont you?
- Loads of comments [SPAM]
- Access to your hosting account where you are hosting the wordpress site. Usually its a Cpanel
- PhpMyAdmin access
- read/write/execute access to your account on SQL database
Here is how you can wipe up the comments which are not approved yet.
- Logon to Cpanel and click on PhpMyAdmin

- In the PhpMyAdmin, select the database that holds wordpress data
-  Click on SQL

- Run the query as below
DELETE FROM wp_comments WHERE comment_approved = 0
If everything is correct, if you logon to the Site Admin Dashboard for the wordpress site, you should not longer see the pending comments.
I would also suggest installing an Akismet plugin that will ensure there are no SPAMs.

NOTE: I am just sharing the above article just to help you out understand the procedure and as you know if you do not know what you are doing, you may always end up breaking stuff. I am not responsible for any damage caused by following above article.

No comments:

Post a Comment