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

Поддержка

simon 09.Декабрь.2018 22:06:55 20

There is now a rake task for this:

4 лайка

Тема		Ответов	Просм.
Help Wiping all Posts from a Forum Support	18	2038	26.08.2020
Delete deleted-posts permanently in bulk? Support	59	5723	08.01.2022
The proper way to completely delete hundred of topics via rails? Support	12	5542	05.02.2021
How to delete EVERYTHING from my forum and just leave the users? Support	30	1500	08.01.2023
Administrative Bulk Operations Self-Hosting configuring , reference	8	14042	25.02.2026

Delete all posts and topics

Связанные темы