Comment by hnben

2 years ago

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

2 comments

hnben

The ".backup" mechanism is safe - it's directly copying the file with "cp" that doesn't work.

Here's how to use .backup:

    sqlite3 data.db ".backup 'backup.db'"

You can also do this:

   sqlite3 data.db 'VACUUM INTO "backup.db";'

That's slower, but results in a smaller backup file: https://www.sqlite.org/lang_vacuum.html