Put web2py in a dropbox folder! Once a day hg commit the entire folder.
On Mar 14, 1:08 pm, Ross Peoples <ross.peop...@gmail.com> wrote: > I am not aware of any way to backup the database along with the application > if you are not using SQLite, however, in appadmin, you could export your > tables to CSV files. You could probably write a backup script in web2py that > does the CSV export. Though the best way is to backup is using your database > engine's backup/restore tools. This is a common problem with many web > applications. WordPress, one of the most widely used web applications in the > world, doesn't even have a good way to handle this. Many plugins try, but > fail in some respect. Their documentation says to backup the folder, then > backup the database separately. > > > > > > > > On Monday, March 14, 2011 11:53:18 AM UTC-4, VP wrote: > > > My understanding is that the database is stored in the web2py app > > folder only if you use SQLite (storage.sql). I think web2py keeps > > information about the models in app/database, but if you use Postgres, > > MySQL, etc., they keep their own copy of the database somewhere else. > > Or does web2py instruct Postgres to store the particular database in > > its own app directory? It would be nice that way. > > > On Mar 14, 9:20 am, JmiXIII <sylvn...@gmail.com> wrote: > > > I would use the pack tool in appadmin, it works well and pack the > > > database and the app in a single file. > > > By the way the database is included in the app so if you compress the > > > whole database you will have the database included in the compressed > > > file. > > > > On 13 mar, 23:57, VP <vtp...@gmail.com> wrote: > > > > > What I have done so far is compress the entire app folder and backup > > > > the database separately. I don't think this is the best way, or is > > > > it? > > > > > Thanks.