DB restore #3715

Closed
opened 2026-04-06 05:35:28 +02:00 by MrUnknownDE · 0 comments
Owner

Originally created by @Biepa on 10/15/2018

Hello together,
I am using the command in the documentation to backup the db.
sqlite3 /$DATA_FOLDER/db.sqlite3 ".backup '/$DATA_FOLDER/db-backup/backup.sq3'"

Unfortunately my knowledge about databases is very limited.
How do I restore a backup.sq3 file?

Tried it with...
sqlite3 db.sqlite3 < backup.sq3
but getting a "syntax error".

Is that because of the different endings?

*Originally created by @Biepa on 10/15/2018* Hello together, I am using the command in the documentation to backup the db. `sqlite3 /$DATA_FOLDER/db.sqlite3 ".backup '/$DATA_FOLDER/db-backup/backup.sq3'"` Unfortunately my knowledge about databases is very limited. How do I restore a backup.sq3 file? Tried it with... `sqlite3 db.sqlite3 < backup.sq3` but getting a "syntax error". Is that because of the different endings?
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github/vaultwarden#3715