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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users