Ghost backup command - HTTPError: Response code 403 (Forbidden)

Developer help Self-hosting
7

My bad.
I was using tool to extract the DB - the tool extracted only the DDL without the data.
This resulted in the error above.

So old DB can be used for ghost.
Export and the import can be done by:

  1. Export from the old server:

mysqldump -u root -p ghost_prod > ghost_backup.sql

  1. The file can be transferred with FilleZilla.

  2. and import on the new one by:

mysql -u root -p ghost_prod < /home/user/ghost_backup.sql

  1. Then change in the

sudo nano config.production.json.

Changing only the DB name (or using ghost setup).

  1. You may need to add the ghost user rights for the new DB:

GRANT ALL PRIVILEGES ON ghost_prod.* TO 'ghost-11'@'localhost' with grant OPTION;

You can find nice guide for migration on this link: