I've been starting work on something similar...
I'm opening the file manually, invoking the Win32 LockFileEx()
function to get myself a shared "reader" lock on the entire file, then
copying..
I guess it'll do, at least until SQLite chooses a different way to
implement locking.
On 05/04/07, Clark Christensen <[EMAIL PROTECTED]> wrote:
I don't know if there are any APIs for backing-up. I don't think there are.
I use this algorithm:
open database using sqlite3_open() or equivalent in your wrapper.
begin immediate or exclusive transaction to lock the database from all other
access
copy the file on the file system
rollback transaction to release the lock
-Clark
- Original Message
From: Paul Richards <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, April 5, 2007 4:23:18 AM
Subject: [sqlite] API for backups
Hi,
Are there functions in the SQLite API for creating live backups of a database?
I see that the sqlite3 command line tool has a "dump" command, but can
this feature be accessed through the normal C API?
--
Paul Richards
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
--
Paul Richards
-
To unsubscribe, send email to [EMAIL PROTECTED]
-