Export clients & client_trusted_domains

[kirrg001]

The Ghost exporter takes care of excluded tables, see https://github.com/TryGhost/Ghost/blob/lts/core/server/data/export/index.js#L11.

These are: token tables, client and trusted domains.

So if you e.g. export your blog and import the file into your new blog, you have to:

1. reconfigure your client credentials if you use the public api
2. you have to re-add trusted domains

We would like to reconsider not exporting clients and trusted domains.

[kirrg001]

@cobbspur FYI. This issue will be resolved in Ghost 2.0. We export more data in Ghost. This can be helpful in case we need to use a backup JSON.

[kirrg001]

The challenge here is that exporting/importing the trusted domains without the clients doesn't work out of the box, because this table holds a MySQL reference to the clients table and MySQL will complain on import.

The connection of clients <-> trusted domains makes it in theory possible that only specific client credentials are tied to a trusted domain.

Keep in mind that Ghost requires the client credentials only for password authentication and the public api. If you are talking to the API with a Bearer token, client validation is skipped, because client authentication happened already.

Options

1. We export+import the clients as well. That means on each JSON import you will override your client credentials. Disadvantage is that in worst case you have to re-new your client credentials for e.g. the public api usage, but you should in theory only import a JSON on a fresh/new blog (e.g. move server from a to b, restore backup because something went wrong)

2. We only export trusted_domains and on import we simply use any existent client id in the database, because the client<>trusted domain feature is not used anyway.

3. We make it optional to import/export specific, excluded tables.

[kirrg001]

3. We make it optional to import/export specific, excluded tables.

We will go with this path for now.

[kirrg001]

Closing, because we have added an hidden option to export/import more tables.