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	2085	August 26, 2020
Delete deleted-posts permanently in bulk? Support	58	6084	December 9, 2021
The proper way to completely delete hundred of topics via rails? Support	10	5595	July 6, 2018
How to delete EVERYTHING from my forum and just leave the users? Support	29	1616	December 9, 2022
How to "migrate" Discourse to Discourse without Site Settings Support	10	2908	March 4, 2019

Delete all posts and topics

Related topics