On 6/7/06, Russell Leighton <[EMAIL PROTECTED]> wrote:
So, this was very enlightening...I have a simple backup function that I now question is correct.It does: - execute "begin" // lock from writes -copy db file to new file byte by byte - execute "commit" // unlock ...I was thinking that "begin" would lock the file.
I believe you want a "BEGIN IMMEDIATE" instead of a "BEGIN". This is how I implemented my own version of it. If it doesn't work would you let us know? -- SqliteImporter, SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite
