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 <[email protected]> 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 <[email protected]> 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.
