Thanks for the reply, Yes Example 2 in https://www.sqlite.org/backup.html is what we are talking about. It was very slow to run for us.
Rob On 4 May 2016, at 12:08, Dominique Devienne wrote: > On Wed, May 4, 2016 at 12:44 PM, Rob Willett > <rob.sqlite at robertwillett.com> wrote: >> We?re trying to backup a 10GB live running database > [...] > >> 2. If we use the command line sqlite <filename> .dump > >> <backupfilename> it >> works, but its very slow. > > That's going to SQL text. > While .backup is page-based, and binary. But not incremental in the > Shell I believe. > >> 3. Using the Sqlite C API works but is also very slow. > > Are you talking about https://www.sqlite.org/backup.html ? > Because Example 2 is exactly your use case. > >> So is there any other method of doing a quick snapshot? > > Well, https://www.sqlite.org/backup.html is the only supported way > IMHO. --DD > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users