We need to migrate all our database to a new bigger server (digital ocean). We need to import only the database (users, passwords, posts, topics etc…) but we don’t want import the site settings, so we can’t use the normal way (backup restore). That’s because in our installation the old admin delet…

I do not think there is any way to import everything except the site settings.

Might it be possible to truncate the site_settings table prior to doing an import? Of course that would still leave the mess caused by deleting and renaming categories, but it should help a bit.

Curious if there exist something like wp. Export content, install new, import.

[صورة] Mittineague: Might it be possible to truncate the site_settings table prior to doing an import? Can you explain how to do that? We can try it in our (local) test site, just installed to make some experimentations. [صورة] Mittineague: Of course that would still leave the mess caus…

Trash: Can you explain how to do that? Save a backup of course. Once you open the database CLI run the query TRUNCATE site_settings AFAIK there are no FKs involved, but maybe the optional CASCADE wouldn’t hurt. [صورة] TRUNCATE TRUNCATE TRUNCATE — empty a table or set of table…

So I need to: unzip a backup open the folder with postgres truncate the site_settings (somenthing like psql -U username -d mydatabase -c TRUNCATE site_settings or psql -U username -d mydatabase -c 'TRUNCATE' site_settings) zip again the backup restore the backup and pray Is all correct @Mitti…

Done. Now we have a new test installation without site settings (except “notification mail”) We still have our data, plugins, groups and categories, and our personal customization (css, html and js). [صورة] But I have the same trouble, staff and lounge categories were not created. The only cat…

Sorry, but where I can find the staff_category_id ? I tried on /site.json (here on Meta too) and I can see the id for all the settings except for stuff category. Is it a hidden id? Where I can find it? Thanks

Yeah I would not recommend nuking the whole site setting table here, but it is possible our site setting import/export rake task could be coerced to do this. We basically want to work through all non hidden settings and revert them to default, some settings are hidden though and you don’t want to t…

How to "migrate" Discourse to Discourse without Site Settings

Support

riking (Kane York) 10 سبتمبر 2016، 10:05م 10

It’s a “hidden” site setting - you can only set it from the Rails console, I think?

الموضوع		الردود	مرات العرض
Preserving site settings through migration Migration	3	971	11 يناير 2022
Backup only Site Settings Support	11	3491	11 سبتمبر 2020
Export and import site settings Self-hosting	4	1872	16 أبريل 2020
Delete all posts and topics Support	18	5202	9 ديسمبر 2018
How can I import/export settings into a file? Support	19	4899	23 مارس 2023

How to "migrate" Discourse to Discourse without Site Settings

الموضوعات ذات الصلة