Hi Igor, On 6 May 2011 14:15, Igor Tandetnik <[email protected]> wrote:
> Jaco Breitenbach <[email protected]> wrote: > > My application has several data files open (one main, several other > > attached) during normal operation. The journaling mode is WAL. I need > to > > perform an online backup of the data files without shutting down the > > application. > > http://sqlite.org/backup.html > > I've also looked at that page. However, that either involves modifying the main application or writing a separate backup utility application based on the examples provided. One thing that I've noticed, is that if the running database that is being backed up is continuously being written to, then following a call to sqlite3_sleep(), the backup will automatically be restarted. This seems to indicate that my backups might never complete. Would a simple copy of the database, -shm and -wal files result in a corrupted database if these files are used to restore the system, or would it simply appear as if SQLite is recovering from a power failure? Sure, there may be a small amount of data loss in doing the copy without a lock, but that may be acceptable so long as the data that is in the database is not corrupted. Jaco _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
