MyBB Community Forums

Full Version: Delete all Threads
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi guys, I imported a mybb database, and now all of my threads "Don't exist"
:3
I don't believe I didn't check the "Threads" option while importing, but regardless, is there a way to delete all of the threads? They aren't 100% necessary.
Well, if you really want to delete all the threads, run:

DELETE * FROM mybb_threads
DELETE * FROM mybb_posts

And also:
DELETE * FROM mybb_threadviews
DELETE * FROM mybb_threadratings

I'm not too sure, as I never ran those queries. So, do it at your own risk and make sure to save a backup.
Go to your Admin control panel -> Tools & Maintenance -> Recount & Rebuild -> Rebuild forum counters / Rebuild Thread Counters.

But you might as well re-count everything to be sure.
Tried recounting, nothing :3

And with the first 2 querys:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM mybb_threads DELETE * FROM mybb_posts' at line 1