On 4 Oct 2016, at 2:53pm, Eric Grange <zar...@gmail.com> wrote:

> I am going on the assumption that if something fails during backup, the
> backup itself will be toast anyway, but is that safe otherwise?

No.  You have no locking.  You might copy the beginning of the file before a 
transaction and the end of the file after it, meaning that pointers at one part 
of the file point to things which no longer exist.

The problem of backing up a changing database is one of the difficult problems 
in database management.  Please don't expect an easy solution.

sqlite-users mailing list

Reply via email to