Ghost Official Database Migration Process?

Developer help Installation
1

OK, starting to get very upset that Ghost has cornered the market and is still so immature!

  1. Your documentation is very lacking. For example how exactly does “ghost setup migrate” work and what exactly is it for? Remember to answer What, When, and Why!

  2. What is your standard procedure for migrating from sqlite to mysql? In this case:
    a) launching a new instance of ghost
    b) exporting json from the old instance (sqlite)
    c) importing the json into the new instance (that’s already setup with mysql)
    d) the new instance lacks API keys that are contained within that json file exported from the first instance. All of the posts, for example, are imported - but I need to get them into the new database for our ghost “integration” to work.

Thanks for your hard work.

1 Like
2

This is a known issue, PRs are welcome :)

3

Can you point me to where in the code I can look into this?

4

Here’s where the data import logic is:

https://github.com/TryGhost/Ghost/blob/master/core/server/data/importer/importers/data/index.js

And here’s where the core import logic (which calls the data import logic) is:

https://github.com/TryGhost/Ghost/blob/master/core/server/data/importer/index.js

1 Like
5

Thanks, I’ll take a look.