4 ms·
> 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]: htt
by leosanchez 6mo 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/ https://gobackup.github.io/
- hedora 6mo agoDoes cp actually work on live sqlite files? I wouldn’t expect it to, since cp does not create a crash-consistent snapshot.
- sgbeal 6mo 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.
- 66yatman 6mo agoMaybe if the system is idle