Comment by yread
2 years ago
Maybe I'm crazy but I just have a cron job that does .backup during a time with little activity. My db is only 40GB or so and stored on an NVMe so it finishes quickly.
2 years ago
Maybe I'm crazy but I just have a cron job that does .backup during a time with little activity. My db is only 40GB or so and stored on an NVMe so it finishes quickly.
Nowadays you're considered crazy if you don't pay rent-seekers for every simple thing.
this comments seems to say, that you could corrupt your copy, if you copy it while it is in use https://news.ycombinator.com/item?id=39838753
The ".backup" mechanism is safe - it's directly copying the file with "cp" that doesn't work.
Here's how to use .backup:
You can also do this:
That's slower, but results in a smaller backup file: https://www.sqlite.org/lang_vacuum.html
thanks!