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] -----------------------------------------------------------------------------