How to Delete bbPress Spam from WordPress Database ? Step by Step

In this short article we will cover – How to clean WordPress Database after uninstalling bbPress ? Many times we receive a good volume of spam on bbPress below steps will help you cleanup your database.

Pre-requisite: Backup your Database and Website. Backup is very important as in case something goes wrong you should be recover your website with no problem.

Deleting Spam from Database

Step 1: Login to your Web-hosting account and go to its Control Panel (cPanel).

Step 2: Ensuring we have a database backup. Go to phpMyAdmin > Make a Database Backup by exporting the database.

Step 3: In phpMyAdmin go to your websites database and we will be working with these 2 tables –

_posts

_postmeta

And what we are looking to delete is posts by id which are in the range where bbPress spam happened

Pro tip: Easy way to find range is make several select statements to see your data at different post id ranges (also check your last created posts id) and figure out from where to delete the posts.

Example – Query like this will get rid of the spam in _posts table

DELETE FROM `blog_posts` WHERE `blog_posts`.`ID` < 4292 and `blog_posts`.`ID` > 2267

and similar query to this will help you clean your _postmeta table as well.

Pro tips: When working with a database please pay attention to the table structure and columns to first understand the table and then execute any delete query using your technical skills.

Select statement are always a safe way to understand databases.

Step 4: Correct Auto-increement value of your table, this will you continue your posts/ids before spam hit your site.

After all the cleanup, check what’s your last left post id.

Select table > Go to Operations

Change Auto-increment value to the last post id. And you are sorted for now.

And if you want to remove bbPress overall from your website, you can use the steps in the video tutorial below.

Uninstalling bbPress

Default image
Navjot Singh Virk
Navjot is a Hobby Blogger from Ireland and loves to create content to help people. He makes time on weekends to work on this blog. And has a full time position at Verizon Media as Lead Technical Solutions Consultant, which he loves and thrives at. His Skills include in-depth knowledge of SEO, Javascript, Advertising, HTML and Java. And his other hobbies include Investing, Gardening and playing Table Tennis.