# Download and restore of site settings

**URL:** <https://meta.discourse.org/t/download-and-restore-of-site-settings/65230>\
**Category:** Development\
**Created:** [27 juni 2017 om 20:43 UTC](https://meta.discourse.org/t/download-and-restore-of-site-settings/65230 "2017-06-27T20:43:26Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [27 juni 2017 om 20:43 UTC](https://meta.discourse.org/t/download-and-restore-of-site-settings/65230/1 "2017-06-27T20:43:26Z")

</div>

For sites interested in moving to Discourse from another forum or trying out Discourse before an import, it’s tedious to see that settings get moved from a test site to the live one, or that settings done on a live instance can be easily moved to a restore from an import that started with a clean slate.

Now that themes are supported, part of this problem is solved, but it’s still tedious to copy potentially dozens of settings from one site to another.

I started looking at a clean (yet naive) way to do this and started by looking at what [data explorer](https://meta.discourse.org/t/32566?silent=true) returns for `select * from site_settings`. That was a good start, but if I reset a value via the web interface, the value still shows up in [data explorer](https://meta.discourse.org/t/32566?silent=true). Is it different in rails?

**Edit:** Another example of my being crazy or looking at the wrong tab. I see now that the setting I changed is still there (of course) but is now blank (as I’d expect). I’d still welcome input on how to best go about this. A plugin that spits out JSON and sucks in an upload?

Any hints on how to go about this?

---

_[View the full topic](https://meta.discourse.org/t/download-and-restore-of-site-settings/65230)._
