Do you know if database can be reused from one server to a new one.
I mean I did migration from one Ubuntu serve to Another.
I followed the steps for Ghost migration.
But data for members, comments etc is missing.
Is it possible to extract the old database. Import it to the new MySQL server and add it to the new ghost installation.
I did quick test with update of sudo nano config.production.json
Chaning the DB name and granting the users for the new DB.
But I got error:
Message: Ghost was able to start, but errored during boot with: Migration lock was never released or currently a migration is running.
Help: If you are sure no migration is running, check your data and if your database is in a broken state, you could run `yarn knex-migrator rollback`.
Suggestion: journalctl -u ghost_user3431-com -n 50
Stack: Error: Ghost was able to start, but errored during boot with: Migration lock was never released or currently a migration is running.
at Server.<anonymous> (/usr/lib/node_modules/ghost-cli/lib/utils/port-polling.js:73:28)
Assuming no changes were done after the migration - no new posts, new comments etc.
I did table per table comparison and I found many differences.
I can upgrade manually most tables but wanted to be sure if there is a better way.