On 2/27/19, Daniel Polski <[email protected]> wrote: > > Is there some way to take a snapshot of a database regardless if there > comes new writes / transactions while doing the backup, and just write a > copy of that snapshot as it was into a new database file?
I assume you are using WAL mode? If not, you should be. Just making that one change might solve your problem. In WAL mode, run the entire backup inside a transaction. Or use the new VACUUM INTO feature to make your backup. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
