Dear experts,

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.

What is the risk in simply copying all files, i.e. data files, -shm and -wal
files to a backup directory?  Could the sqlite3 built-in .backup command be
used while the application is accessing the data files?  Is there a specific
backup utility available for SQLite?

Any comments and suggestions will be much appreciated.

Regards,
Jaco
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to