I have imported about 500,000 posts to my discourse instance. i would like to delete all posts and topics to re-import all my posts. does anyone have any idea how to do this?

If you want to start from scratch, I would use the rails console to re-create a new database rails db:drop db:create db:migrate :warning: THIS WILL DELETE EVERYTHING (users, site settings, etc…) :warning:

the thing is i want to keep all the other settings i have.

design, site name… and other settings my client may have changed. i don’t see why i would have to reset everything. there gotta be another way.

In that case, you could do this in the rails console Post.order(id: :desc).each do |post| PostDestroyer.new(Discourse.system_user, post).destroy end

this is working wayy to slow. it deleted about 10000 posts in about 1 hour. is there anyway to do this faster?

Only the first method I mentioned will. If you use anything else, you will end up with an inconsistent database.

is there a way to backup only the settings?

I’m afraid not yet. But you can do it manually. All the settings (ie. /admin/site_settings) are stored in the site_settings table. Just dump that table and restore it once you’ve re-created the database.

i do not come from the rails world, is it to much to ask how i can do that?

Delete all posts and topics

Support

simon December 9, 2018, 10:06pm 20

There is now a rake task for this:

Topic		Replies	Views
Help Wiping all Posts from a Forum Support	18	2064	August 26, 2020
Delete deleted-posts permanently in bulk? Support	59	5825	January 8, 2022
The proper way to completely delete hundred of topics via rails? Support	12	5571	February 5, 2021
How to delete EVERYTHING from my forum and just leave the users? Support	30	1538	January 8, 2023
Administrative Bulk Operations Self-Hosting configuring , reference	8	14119	February 25, 2026

Delete all posts and topics

Related topics