Re: [web2py] Re: Expoerting then importing isn't working...

2010-09-02 Thread Thadeus Burgess
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,

[web2py] Re: Expoerting then importing isn't working...

2010-09-02 Thread selecta
+1 for complete database backup and restore On Sep 2, 11:55 am, Jason Brower 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 datab

Re: [web2py] Re: Expoerting then importing isn't working...

2010-09-02 Thread Jason Brower
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

[web2py] Re: Expoerting then importing isn't working...

2010-09-01 Thread mdipierro
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

[web2py] Re: Expoerting then importing isn't working...

2010-09-01 Thread selecta
I encountered the same problem when copying auth_user auth_group auth_membership user and group went fine, even the ids are identical to those of the original db but copying auth_membership gives me undefine_record errors On Sep 1, 12:48 pm, Jason Brower wrote: > I have 3 tables to make a many t