Do you want to delete all comments from your WordPress site?
It is rare, but sometimes you may need to delete all the comments on your WordPress website. If you have lots of comments, then it could take you a lot of time and effort to delete them manually.
In this article, we will show you how to easily bulk delete all WordPress comments.
Before You Delete All WordPress Comments
Although it’s rate, there are some reasons why you might need to permanently delete all comments from your WordPress blog or website.
For example, maybe you posted lots of dummy comments on a development site or during testing. You will definitely want to delete all those fake comments before moving to a live site.
You may also be taking your WordPress blog in a completely new direction and want to remove all traces of your website’s past.
However, deleting all comments across your site isn’t always the answer.
If you just want to delete spam comments, then we recommend following our guide on how to batch delete spam comments in WordPress. After that, check out our tips and tools to combat comment spam in WordPress so you don’t get the same problem again.
If you have thought it through and still want to delete comments, then we recommend creating a complete WordPress backup of your site first. Deleting all comments isn’t something you can undo, so it’s important to have a backup just in case you change your mind.
With that being said, let’s see how you can easily bulk delete all WordPress comments. Simply use the quick links below to jump straight to the method you want to use.
Method 1: Deleting All WordPress Comments Using a Plugin (Easy)
The easiest way to delete all WordPress comments at once is by using a plugin.
Upon activation, go to Tools » Delete Comments.
This page will display the total number of comments on your WordPress website and give you the option to delete them.
You can choose to delete all WordPress comments, pending comments, spam comments, or comments that are already in the trash.
To delete all WordPress comments, go ahead and select ‘All Comments’ and then click on the ‘Delete Now’ button. Just be aware that the plugin won’t give you a chance to change your mind, so only select ‘Delete Now’ if you’re certain you want to permanently remove all comments from your WordPress site.
Method 2: Delete All WordPress Comments Using phpMyAdmin (No Plugin Required)
You can also quickly delete all WordPress comments using MySQL or phpMyAdmin. This method allows you to bulk delete comments without installing a plugin, but it’s only recommended for more advanced users.
Note: Just like the plugin method, you won’t be able to recover deleted comments. With that in mind, you will need to make a complete WordPress backup using a plugin such as Duplicator Pro before moving forward.
Under the ‘Databases’ section, just click on ‘phpMyAdmin.’
Inside phpMyAdmin, you will need to find your WordPress database.
After that, you will see a page showing all your WordPress database tables.
You can simply check the box next to the
wp_commentmeta tables. Just be aware that the name of your comments tables may differ depending on the table prefix you chose when you installed WordPress.
After selecting the comments table, find the ‘With selected:’ dropdown menu below the table list. Then, choose ‘Empty’ from the dropdown menu.
phpMyAdmin will now ask whether you are sure you really want to execute the query, which will permanently delete your comments.
If you are happy to go ahead, then click ‘Yes.’ This will remove all the comments from your WordPress website.
We hope this article helped you learn how to easily delete all comments in WordPress. You may also want to see our expert picks for the best contact form plugins and the ultimate WordPress security guide.