WP Rocket - WordPress Caching Plugin
Rolecosplay

~Just the Facts~

Delete Spam Comments in Bulk Without Plugins on Cloudways

written by Divi Dude

Sometimes you screw up and forget to turn off comments on your WordPress website, or forget to configure your Askimet, or do both, and then you end up with thousands of comments that are nothing but spam. We’re talking hundreds of pages worth of comments that need to be deleted.

I’m not saying that happened to me with my work-in-progress Game of Thrones Divi website.  I’m not saying that in the course of 1 week, I got more than 5,000 spam comments.  I’m just saying sometimes it happens, and when it does, deleting the spam comments in bulk is relatively easy without having to resort to adding another plugin to your website.

There’s a video towards the bottom of the page, if you prefer to get your tutorials that way.

Delete Bulk Comments in WordPress

I use Cloudways as my server.  And if you are serious about designing websites for you and your clients, then I recommend you use Cloudways too.  I wrote an article on why I use Cloudways instead of a less expensive shared hosting plan that you should read.  But I digress.

If you’re on another server, the principles remain the same; it’s just the way to get there will be slightly different depending on how you edit your MySQL database, most likely you will use phpMyAdmin.

This is how to delete your comments in bulk on Cloudways:

  1. Back up your database in case something goes wrong. (You can export it under settings, or duplicate the site using a plugin like Duplicator, or create a clone or staging site on Cloudways).
  2. Launch your application (another word for WordPress website).
  3. When the application is launched, make sure you click on the Access Details on the left-hand menu (it should have defaulted there, but if not, click on it).
  4. On the bottom is a green button that reads: “Launch Database Manager.” Click on it.
  5. Look for the wp_comments table and click on it.
  6. Click on the “Select Data” link on top.
  7. Scroll down to the bottom and check the box that reads: “Whole Results”.
  8. Click on the green Delete Button.
  9. Return to the table by clicking on the database name up top in the breadcrumbs menu in the blue section. (or just hit the back button a couple of times until you are in the database manager again).
  10. Look for wp_commentmeta and click on it.
  11. Repeat steps 6 & 7.
  12. That’s it. Close the screen.

When you go back to your WordPress website’s dashboard and hit refresh, all the comments will be gone.

Helpful Tips to Avoid Spam Comments

If you don’t want to comments, make sure to turn them off on your website.  Do this by going to the Settings > Discussion and unchecking the box that reads: “Allow people to post comments on new articles”.  Also, be sure to check the box that reads: “Comment must be manually approved” in case any still do appear, or if you do allow comments on your website.

WordPress comes with the plugin Askimet Anti-Spam.  Make use of it.  Sign up for an API key and make sure the plugin is activated.

MAKE YOUR DIVI LIFE EASIER

Divi Booster is a Divi plugin that just makes your life as a website developer easier. It adds about 50 functions to the already impressive Divi WordPress theme. Want an example? Here’s a video  I did showing the long way and the short way to add additional social media pages to your Divi theme (guess which plugin I used to show the short way). But it doesn’t just help with social media, it also allows you to make adjustments to sliders, headers, posts, pages, modules … like I wrote above, it does about 50 things (I write “about” because it is continuously updated with more functions). $29.

Instagram Training




Faster WordPress Hosting

Load WordPress Sites in as fast as 37ms!

Build Better Websites

Affordable Domain Registration

Get $1.00 off.
DiviDudeWeb16

Big Discounts for Domains, Hosting, SSL and more

Subscribe

Must Have Plugins

WP Theme FAQs

WP Rocket - WordPress Caching Plugin

Duplicator Pro: WordPress Backups Made Simple

Favorite WordPress Theme

Divi WordPress Theme

Start Your Newsletter

For Your Inner Nerd

Rolecosplay Movie Costumes

Latest Divi Dude Tutorials

Affiliate marketer: Which means when you click a link and purchase an item, I may receive a commission. As an Amazon Associate I earn from qualifying purchases. Thank you for your support.

Join Our Awesome List

Join our mailing list to receive the latest news and updates from Divi Dude. We don't write often, but when we do, everything will more or less be spelled correctly (oh, and be interesting and fun and knowledge based).

Thanks Dude! You've successfully subscribed.

Pin It on Pinterest

Share This