# How can I import/export settings into a file?

**URL:** <https://meta.discourse.org/t/how-can-i-import-export-settings-into-a-file/51496>\
**Category:** Product Support\
**Created:** [2016 年10 月 13 日 11:41 UTC](https://meta.discourse.org/t/how-can-i-import-export-settings-into-a-file/51496 "2016-10-13T11:41:59Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

作者： ![bek](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/bek/32/61660_2.png) [@bek](https://meta.discourse.org/u/bek)\
发布日期： [2016 年10 月 13 日 12:35 UTC](https://meta.discourse.org/t/how-can-i-import-export-settings-into-a-file/51496/2 "2016-10-13T12:35:26Z")

</div>

I guess probably you can export your settings from DB.

```plaintext
discourse=>\dt
...
...
 public | single_sign_on_records | table | discourse
 public | site_customizations | table | discourse
 public | site_settings | table | discourse
 public | stylesheet_cache | table | discourse
...
...

```

Notice site\_settings table. You can also take this data from your backup. It already have a dump of your database inside it.

Then all you need to do is restore this table to your server from your local dump. 👍

---

_[View the full topic](https://meta.discourse.org/t/how-can-i-import-export-settings-into-a-file/51496)._
