Liquid Web Hosting

Home Wordpress How to Bulk Delete All WordPress Comments?

How to Bulk Delete All WordPress Comments?

March 10, 2016 By admin

Today we see about how to bulk delete all WordPress comments on your site. We have used two methods to remove all of your WordPress site comments. I will list those two approaches in the below paragraphs.

Think Before Bulk Delete All WordPress Comments

There are many situations you want to delete all of those comments from your WordPress site.

For example, I created my first dummy sites with comments, before start to move my site to live server I have deleted all of the dummy comment from the site.

Sometimes website owners don’t want to see comments on their site in that time they will remove comments.

If you receive lots of spam comments, then you can use Akismet plugins for to reduce your spam comments on your site.

You can also disable comments section using your WordPress dashboard.

If the above situations are not for you, then read and apply the below methods for you.

Before start to delete all of your comments first Backup your site.

If you delete all of the comments, you will not undo this process because WordPress would not allow. This is the main reason I recommended to you to backup your site.

There are two methods available to delete all of those unwanted comments.

Delete All Comments Using Plugin

The Delete all Comments plugin can be used to remove all of the comments on your site.

After activating your plugin, you navigate to the plugin page; it shows you how many comments are available. You can select all comments from the dashboard and delete all of those comments just a single click.

This plugin removes all comments including spam and trash from your site.

Use phpMyAdmin and MySQL to Delete All Comments

In this method, you can delete comments quickly without any effort. We use both MySQL and phpMyAdmin for delete all comments from our site.

Liquidweb Offers one of the industry standard cPanel for their customers you will use our agency Liquidweb Coupon to get industry standard panel for your websites.

phpmyadmincpanel lweb

If you want to apply this method, first you need to login to your cPanel of your server and then click the phpMyAdmin.

Bulk Delete All WordPress Comments

After move inside of your phpMyAdmin panel, you need to locate your WordPress site database and find comment table names in your database. Those table names are wpprefix_comments and wpprefix_commentmeta and table names are differ based on your table prefix you already choose during the WordPress install.

After selecting comment section table in your database and locate your ‘with selected’ drop down menu and click the empty menu. They will show a warning message and click yes they will delete all of your comments on your site with a single click.

And another method removes all comments using MySQL console. First login to your MySQL consoles and type the below line they will delete all comments automatically.

1. TRUNCATE `wp_commentmeta`;
2. TRUNCATE `wp_comments`;

We hope you learned a lot of things from this post if you have any doubts about this post How to Bulk Delete All WordPress Comments? Please ask your questions using the comment section.

Filed Under: Wordpress Tagged With: wordpress comments

LiquidWeb Dedicated Hosting

Recent Posts

  • 5 Best Shared Hosting Provider – Recommended for your Clients
  • The Full Guide To WooCommerce SEO For Your Business
  • Different Types of Web Hosting Explained – Web Hosting Beginners
  • 10 Best WordPress FAQ Plugins For Your Website
  • What is Caching in WordPress?

Google Plus

Copyright © 2018 LwebCoupons All rights reserved | Blog .Affiliate Disclaimer . Privacy PolicyContact Us