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 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 copy the file: you might get the database > in an inconsistent state. Use the sqlite3 .backup command instead to take a > snapshot. Send its output to a dropbox folder if you like. > > > 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 interesting suggestion from Massimo: >> >> >> Put web2py in a dropbox folder! Once a day hg commit the entire folder. >> >> >> That sounds good, but would it make a safe copy of the data? >> >> In any case, does anyone have other ideas? >> >> Regards, David > > > >