Thanks for the responses. I'll probably write a little c++ program to use the online backup API. Josh
On Apr 5, 2010, at 3:07 PM, D. Richard Hipp wrote: > > On Apr 5, 2010, at 5:42 PM, Joshua Redstone wrote: > >> Hi sqlite-users, >> I'm looking for an easy way to backup a sqlite3 database while it is >> in use. If I could get away with linux 'cp', that'd be easier than >> writing c++ code according to the online backup API >> (http://www.sqlite.org/backup.html >> ), and also it has the advantage that it would not block writes. >> Initially I thought that 'cp' would be safe because sqlite is crash- >> safe, but then I realized that 'cp' is not atomic, so it's possible >> it won't work. >> Thoughts? > > Right. "cp" is not atomic. "cp" will *usually* work, but sometimes > you will get unluck and the database will change in the middle of the > "cp" and what you end up with will be the first have of one database > and the second half of a different database. > > The backup API is safer. > > > >> Thanks, >> Josh >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users