CODEWITHSUNDEEP
mysqlwordpressbbpress
Syed Umar Ahmed
Syed Umar Ahmed

Reputation: 5952

Delete all the data of BBPress

I would like to delete all the data related to bbPress Wordpress, some how millions of records are inserted into my blog and i will use this query to delete the records

DELETE from wp_btei_postmeta 
where 
Post_id IN (select distinct ID from wp_btei_posts where post_type in ('forum', 'topic', 'reply'))

I want to know is this the right thing I am doing ? Will it delete other data than my forum ? because i read on BBPress that they use the above three types of post and uses the main post table only.

Upvotes: 1

Views: 1601

Answers (1)

netweb
netweb

Reputation: 632

bbPress includes a tool to delete all the bbPress data

  • Install and activate the bbPress plugin again
  • Go to Tools -> Forums -> "Reset Forums" tab
  • Check the "Are you sure you want to do this?" checkbox
  • Click "Reset bbPress"
  • Deactivate and delete the bbPress plugin

This will remove all bbPress data from your WordPress database, including custom post types, topic tag taxonomy and user meta.

Upvotes: 2

Related Questions