I did a backup of my site before I upgraded to the latest version of the discourse however I can’t even access my site any more even though the upgrade appears to be successful as no error is displayed. Is there anyway that I can restore my site from the backup that I created earlier from terminal app as I can’t access the site? Is it possible? If yes, where do discourse save or store the backups that I executed from the admin panel? Is there any guide on how to restore the site from backup? Thanks

[image] Ankhamax: Is it possible? Yes. [image] Ankhamax: If yes, where do discourse save or store the backups that I executed from the admin panel? They’re stored in public/backups/default/. [image] Ankhamax: Is there any guide on how to restore the site from backup? Just run the following command (in the discourse directory) script/discourse restore

This seems like a handy thing to be able to do since if you screw up configuring SSO you can’t get back into your site. So, script/discourse restore fails because thor isn’t installed. gem install thor fixes that, but then I’m still denied because: URGENT: FATAL: Peer authentication failed for user "discourse" Solving my immediate problem, I suppose I could turn off SSO from the Rails console. . . edit: to disable SSO from the rails console: cd /var/discourse ./launcher enter app rails c SiteSetting.enable_sso=false exit exit

[image] pfaffman: since if you screw up configuring SSO you can’t get back into your site. There’s a way to log in: Visit /users/admin-login, which can be used to log in via email :slight_smile:

It worked for me by first getting into the app ./launcher enter app then discourse enable_restore discourse restore discourse disable_restore Using the script/discourse didn’t work

restoring from a app.yml and an external tar.gz file was mixing up some of the items I found along this thread: TARBALL_PATH=$(ls local/backups/-*.tar.gz | tail -n 1) TARBALL_NAME=$(basename ${TARBALL_PATH}) cat ${TARBALL_PATH} | docker exec -i app sh -c "cat - > /var/www/discourse/public/backups/default/${TARBALL_NAME}" docker exec -i app sh -x << EOF discourse enable_restore discourse restore ${TARBALL_NAME} discourse disable_restore EOF I had several pitfalls: the tarball to restore has to be placed exactly in /var/www/discourse/public/backups/default/ the /var/www/discourse/script/discourse restore tarball-name did not work due to some single sign-on known issue the version of thor installed by gem install thor was too recent and then incompatible with the rest. finally one of the tarball I tried to restore from did not contain the “meta.json” file… Hope this helps other in their restore journey.

Rather than try to restore from app.yml it’s much easier to just ./launcher enter app and restore it from the command line.

The goal was to automate it without any entering container with the launcher. Imagine your instance got lost for any reason. The only files you stored in git was your containers/app.yml and luckily you have a daily tarball backup.

You can also do it directly to Postgres: dropdb dbname createdb dbname gunzip -c filename.gz | psql dbname

discourse is script/discourse – executed via bundle exec and with rails_env=production. Look at /usr/local/bin/discourse. Running bundle exec script/discourse takes care of the thor mismatched gem version, too. Or just using the discourse convenience script.

Is there any way to restore your site from backup in the terminal?

Product Support

gerhard (Gerhard Schlager) August 14, 2020, 10:05am 16

You can’t. You need to copy the backup file into the correct directory. Please follow the instructions at Restore a backup from the command line if you want to restore from the command line.

Topic		Replies	Views
Restore a backup from the command line Self-Hosting how-to	18	23145	May 18, 2025
Backup discourse from the command line Self-Hosting backups , how-to	12	13075	July 23, 2026
Data Backup Self-hosting	5	1963	December 10, 2023
How to backup Docker discourse from command-line before rebuilding broken Discourse? Product Support	12	4349	May 23, 2019
How to restore backup tar.gz file from console command? Product Support	8	3780	January 8, 2018

Is there any way to restore your site from backup in the terminal?

Related topics