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 backup a sqlite3 database

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

2010-04-05 Thread Simon Slavin
On 5 Apr 2010, at 10:42pm, Joshua Redstone wrote: > 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

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

2010-04-05 Thread D. Richard Hipp
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 >

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

2010-04-05 Thread Pavel Ivanov
Just a little logic: if you want some backup mechanism that won't block writers then what state the backed up database should be in? In the state that was when backup process started or in the state that was when backup process ended? If the former then how would you distinguish file contents that

[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