Export to json without web ui/with cli

Hi. Is there any way I can export to JSON without using the web interface? Could I use the CLI? I want to back up the site. I have the database but if I just transfer the database the error continues, even on a new install, so I just want to export posts, users, etc. and not migrations, migrations_lock and other configuration. Any ideas?

  • What’s your URL ? https://blog.eddiestech.co.uk
  • What version of Ghost are you using? Latest
  • How was Ghost installed and configured? using the ghost-cli ( ghost install local )
  • What Node version, database, OS & browser are you using? Node v12.20.1, sqlite3, Ubuntu 20.04.1 LTS, Chrome
  • What errors or information do you see in the console? Migrations are being run at the moment. Please wait that the locks get released.