← Back to context

Comment by leosanchez

3 days ago

> Backups are cp production.sqlite3 backup.sqlite3

I use gobackup[0] as another container in compose.yml file which can backup to multiple locations.

[0]: https://gobackup.github.io/

3 comments

leosanchez

Reply
hedora  6 hours ago

Does cp actually work on live sqlite files? I wouldn’t expect it to, since cp does not create a crash-consistent snapshot.

  • sgbeal  3 hours ago

    > Does cp actually work on live sqlite files? I wouldn’t expect it to, since cp does not create a crash-consistent snapshot.

    cp "works" but it has a very strong possibility of creating a corrupt copy (the more active the db, the higher the chance of corruption). Anyone using "cp" for that purpose does not have a reliable backup.

    sqlite3_rsync and SQLite's "vacuum into" exist to safely create backups of live databases.