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