Re: [sqlite] Is it safe to backup an in-use sqlite3 database by copying the underlying database file?

2010-04-05 Thread Joshua Redstone
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 back

[sqlite] Is it safe to backup an in-use sqlite3 database by copying the underlying database file?

2010-04-05 Thread Joshua Redstone
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