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

Unterstützung

simon 9. Dezember 2018 um 22:06 20

There is now a rake task for this:

Thema		Antworten	Aufrufe
Help Wiping all Posts from a Forum Support	18	2111	26. August 2020
Delete deleted-posts permanently in bulk? Support	58	6321	9. Dezember 2021
The proper way to completely delete hundred of topics via rails? Support	10	5623	6. Juli 2018
How to delete EVERYTHING from my forum and just leave the users? Support	29	1685	9. Dezember 2022
How to "migrate" Discourse to Discourse without Site Settings Support	10	2918	4. März 2019

Delete all posts and topics

Verwandte Themen