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 9 בדצמבר,‏ 2018,‏ 10:06pm 20

There is now a rake task for this:

נושא		תגובות	צפיות
Help Wiping all Posts from a Forum Support	18	2112	26 באוגוסט,‏ 2020
Delete deleted-posts permanently in bulk? Support	58	6500	9 בדצמבר,‏ 2021
The proper way to completely delete hundred of topics via rails? Support	10	5624	6 ביולי,‏ 2018
How to delete EVERYTHING from my forum and just leave the users? Support	29	1709	9 בדצמבר,‏ 2022
How to "migrate" Discourse to Discourse without Site Settings Support	10	2924	4 במרץ,‏ 2019

Delete all posts and topics

נושאים קשורים