+1 for complete database backup and restore
On Sep 2, 11:55 am, Jason Brower <encomp...@gmail.com> 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 <encomp...@gmail.com> 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