Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can you explain how to restore the database? #39

Open
72521 opened this issue Jul 23, 2024 · 0 comments
Open

Can you explain how to restore the database? #39

72521 opened this issue Jul 23, 2024 · 0 comments

Comments

@72521
Copy link

72521 commented Jul 23, 2024

The sqlite3 database was backed up as backup.bak.
"sqlite3 /data/db.sqlite3 '.backup /data/backup.bak'"

To restore the db.sqlite3 database, should I simply rename backup.bak back to db.sqlite3? or should I use a command for sqlite3 itself when launching a new Vaultwarden app from fly.io? What are the recommended steps for database restoration? Could you please provide a slightly more detailed step-by-step?

here are my steps now:

# create a new empty Vaultwarden service
task fly:app:create
task fly:volume:create
task fly:app:deploy

task fly:app:ssh

overmind stop vaultwarden
overmind stop caddy
overmind stop backup

rm -rf /data

restic snapshots
restic restore bd6ce73f --target /

mv /data/backup.bak /data/db.sqlite3

overmind start
@72521 72521 changed the title Can you explain how to restore the database from restic? Can you explain how to restore the database? Jul 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant