AI Search
Classic Search
Notifications
Clear all
Jul 25, 2026 12:35 pm
I need to reduce rows in the database. What is the best way to do this with wpforo data?
Also, what does the 'clean up' button do?
2 Replies
Jul 25, 2026 3:10 pm
Hi,
To reduce rows and database bloat in wpForo, you should remove old or spam content and clean up unneeded log data. Because direct database deletion is permanent, start by backing up your site.
Here are the best ways to do this:
1. Delete Old Topics and Posts
You can remove old discussions directly from your dashboard or via SQL.
- Via Dashboard: Go to Forums > Moderation > Published and filter by date to manually delete outdated threads.
- Via SQL: To automatically delete all posts and topics older than a specific timeframe, you can execute targeted delete queries in your phpMyAdmin dashboard.
2. Purge Spam and Trashed Content
Accumulated spam posts and topics drastically inflate your row count.
- Go to Forums > Moderation in your WordPress admin panel.
- Select the Spam or Trash tab.
- Use the bulk actions menu to Delete Permanently.
3. Clear Caches and Editing Logs
wpForo creates temporary caching rows for faster rendering and logs edit history.
- Clear Forum Cache: Navigate to wpForo > Overview and click [Delete All Caches].
- Limit Edit Logs: Go to wpForo > Settings > Posting & Editor Settings and reduce the number of editing logs stored.
The "Clean Up" button in wpForo is a built-in database maintenance tool designed to delete orphaned topics or broken forum structures.
Jul 26, 2026 9:48 am
Thank you!