Re: [web2py] Re: Website/Sqlite Backup

2012-07-12 Thread villas
Regarding use with Apache wsgi and Sqlite. Does anyone know whether it is safe to copy a Sqlite DB file after Apache has been stopped. I mean, would stopping Apache leave the DB file in a good state for copying?

Re: [web2py] Re: Website/Sqlite Backup

2012-07-12 Thread Jonathan Lundell
On 12 Jul 2012, at 4:56 AM, villas wrote: Regarding use with Apache wsgi and Sqlite. Does anyone know whether it is safe to copy a Sqlite DB file after Apache has been stopped. I mean, would stopping Apache leave the DB file in a good state for copying? This issue is not so much Apache

Re: [web2py] Re: Website/Sqlite Backup

2012-07-12 Thread villas
Jonathan, Thanks for your comments. I believe there would only be my web apps writing to the DB, so from what you say it's probably OK to do the copy after I stop Apache although this is still not the favoured solution. For the record, the other (better) solutions are: 1. Use Sqlite

[web2py] Re: Website/Sqlite Backup

2012-07-11 Thread Massimo Di Pierro
If you pay the $100, dropbox has a 6month restore. I do not know if it will save all the versions of the file, or only some snapshot. On Wednesday, 11 July 2012 03:16:29 UTC-5, villas wrote: Hi All, I'm looking for any easy way to backup small websites which use Sqlite. I found an

Re: [web2py] Re: Website/Sqlite Backup

2012-07-11 Thread Jonathan Lundell
On 11 Jul 2012, at 7:25 AM, Massimo Di Pierro wrote: If you pay the $100, dropbox has a 6month restore. I do not know if it will save all the versions of the file, or only some snapshot. I wouldn't count on dropbox to safely back up a live sqlite database, for the same reason you can't simply

Re: [web2py] Re: Website/Sqlite Backup

2012-07-11 Thread Massimo Di Pierro
You are right. On Wednesday, 11 July 2012 09:47:17 UTC-5, Jonathan Lundell wrote: On 11 Jul 2012, at 7:25 AM, Massimo Di Pierro wrote: If you pay the $100, dropbox has a 6month restore. I do not know if it will save all the versions of the file, or only some snapshot. I wouldn't count on

Re: [web2py] Re: Website/Sqlite Backup

2012-07-11 Thread villas
Thanks guys! I didn't even know there was a backup command. That, with the dropbox, sounds perfect. Hope it all works with cron, I have to investigate. Best wishes, David On Wednesday, July 11, 2012 3:47:17 PM UTC+1, Jonathan Lundell wrote: On 11 Jul 2012, at 7:25 AM, Massimo Di Pierro