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

Reply via email to