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

Supporto

simon 9 Dicembre 2018, 10:06pm 20

There is now a rake task for this:

Argomento		Risposte	Visualizzazioni
Help Wiping all Posts from a Forum Support	18	2090	Agosto 26, 2020
Delete deleted-posts permanently in bulk? Support	58	6170	Dicembre 9, 2021
The proper way to completely delete hundred of topics via rails? Support	10	5605	Luglio 6, 2018
How to delete EVERYTHING from my forum and just leave the users? Support	29	1674	Dicembre 9, 2022
How to "migrate" Discourse to Discourse without Site Settings Support	10	2918	Marzo 4, 2019

Delete all posts and topics

Argomenti correlati