How To Delete All WordPress Comments At Once

How to Easily Bulk Delete All WordPress Comments (By Plugin & By phpMyAdmin)

Blog writers love comments because it makes their blog engaging and people also love comments because they know the value of feedback or pre-asked questions.

It saves their time and helps them to have trust in any blog contents. In this post, I will show you that how to delete all WordPress comments.

There are many reasons for anyone to delete WordPress comments. Might be someone made many dummy comments at the time of development of any blog or someone is tired due to spam comments. Or someone decided not have any comments on his blog and wants to disable comments feature.

There are two ways of deleting WordPress comments. Either use any plugin or by phpMyAdmin. I will teach you both ways of deleting comments in WordPress.

1. Delete all WordPress comments by a  plugin

There is a plugin called Delete all comments easily which allows you to delete comments in WordPress with one click. It has the capability to delete all Approved, Pending, Spam and Trashed Comments on your WordPress blog.

How to use Plugin:

Go to plugins section – add new plugin – search delete all comments easily and install and activate it.

plugins to Delete All WordPress Comments

Now go to Tools section and click on the plugin.

delete all comments easily

After opening it, it will show you all Approved, Pending, Spam, and Trashed Comments.

comments counts

Now select the checkbox and click on below given box. It will delete all of the comments on your WordPress blog.

Note: Once comment deleted can’t be restored.

wordpress comments - success message

 

2. Delete all WordPress comments using phpMyAdmin

It is very easy to delete WordPress comments in bulk in one click. Follow a few steps as given:

1- Login to your control panel

2- Open phpMyAdmin.

How To Delete WordPress Comments Using phpMyAdmin

3- Locate your database and select it.

4- You will see all the database table right side

5- Select top two wp_comments and wp_commentmeta table. For me, these are sv_comments and sv_commentmeta, because, I used SV_ prefix instead of WP_ at the time of installing WordPress. You will see prefix whatever you used.

Delete WordPress Comments Using phpMyAdmin

There are two ways to delete all comments after selecting sv_commentmeta and sv_comments.

Let me show you both method to delete comments:

I- First Method:

Click on Empty given in front of each (Highlighted in violet color in the above picture).

It will ask you to confirm whether you want to truncate table or not?

empty comments

Once you clicked on OK and your comments will be deleted.

Note: Here, you have to truncate table one by one. It will not truncate both together. Select one first and truncate it and then select the second one and truncate it.

II- Second Method:

Select top two wp_comments and wp_commentmeta table. For me, these are sv_comments and sv_commentmeta.

second method to delete comments

After selecting both table scroll down the page until the end. Here, select Empty from With Selected drop-down box.

empty comments phpmyadmin

After selecting Empty, it will ask for your permission to execute a query to truncate comments, Click on Yes.

execute query to delete comments

You will see that all comments have been deleted from your WordPress Blog.

Leave a Reply