Easy. db.export_to_csv(...) db.import_from_csv(...)
This will export all tables. There just is not an interface to do this in appadmin. I think I have some examples... here http://code.google.com/p/blogitizor/source/browse/src/controllers/admin.py -- Thadeus On Thu, Sep 2, 2010 at 7:09 AM, selecta <[email protected]> wrote: > +1 for complete database backup and restore > > On Sep 2, 11:55 am, Jason Brower <[email protected]> wrote: >> Woot! Thanks... that did it. While I was add it I made a "backup and >> restore database" feature in my setup. It would be nice if we could >> export a database to a "web2py" format. A gzipped file of all databases >> in one sweep. It could then be restored quickly as well. >> Best Regards, >> Jason Brower >> >> >> >> On Wed, 2010-09-01 at 06:39 -0700, mdipierro wrote: >> > It works but not via appadmin. >> >> > If you want to import data from two tables which reference eahc other >> > you must to: >> >> > id_map={} >> > db.table.import_from_csv_file(csvfile1,id_map=id_map) >> > db.table.import_from_csv_file(csvfile2,id_map=id_map) >> >> > passing the same id_map makes sures the relative references are fixed. >> >> > On Sep 1, 5:48 am, Jason Brower <[email protected]> wrote: >> > > I have 3 tables to make a many to many relationship. >> > > I can export the two. But the linking table for the many to many keeps >> > > giving me an error of "undefined record" meaning it's trying to >> > > reference to something that doesnt exist. These datbases are clean when >> > > I start. and I am doing a direct export and import with the csv feature. >> > > Am I missing something or do we have some kind of bug. >> > > Best Regards, >> > > Jason Brower >
