So, I managed to import my age old forum into Discourse, and I madea Discourse backup of it. Later I will put it down in a production environment and make the static archive. Right now I’m on a developoment build. But now I’m running into a problem: I would like to clear out the database and insert …

Easiest is to drop the database and create a new one: rake db:drop db:create db:migrate.

It’s probably also a good idea to remove uploads: rm -fr public/uploads I once leaked a load of virus-infected uploads from one site I imported to another client. :sadpanda: Here is a gist of my new_discourse_database script that kills any running rubies (you can’t drop the database if rails s …

I only have the dump, so this is not an issue

After running bundle exec rake db:drop db:create db:migrate I get the following error: == Seed from /home/jsilvanus/discourse/db/fixtures/500_lounge_category.rb rake aborted! ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column groups.visible does not exist LINE 1: ...AS t1_r22, "gro…

I ran into the same problem today. Quick workaround: Call db:migrate twice.

Hi, we had a user field which has been removed during time. but some users has already filled it. Is there anyway to remove or clear those entries from the database? the reason I want to remove it, is that It’s annoying some of our old users, as they can’t change the field anymore. I’ve already tr…

I’m trying to delete a database that I’m using to test an import as well, but running the following command didn’t delete anything: bundle exec rake db:drop db:create db:migrate When I refresh, I still see all the data from the previous import. Is there anything else I need to do to complete wipe…

Have a look here [image] DB Ownership / Wiping out Production Self-hosting Just to leave some feedback here, since I had to re-do this today. What eventually worked for me is to delete the full /docker-app/standalone directory no need to stop the container,…

I find it easier to make a backup just after setting up the site and then restoring it.

Clear, empty, delete database for another import (development)

Support

pgr April 17, 2020, 9:04am 9

Have a look here

Topic		Replies	Views
Database Cleanup while writing a new Import Script Development	8	1420	December 10, 2018
Purging user data from dev install Development	5	1226	October 24, 2016
Delete all posts and topics Support	18	5023	December 9, 2018
How to reset discourse on dev mode? (w/o docker) Support	1	1242	May 19, 2020
Importing old database to latest version Self-hosting	16	1370	June 7, 2022

Clear, empty, delete database for another import (development)

Related topics