Not very orthodox method here, but let say you have dump just the data and want to let web2py recreate everything...
Make a backup of the app before do anything else so you can restart over if it not working properly with previous state. Then go in the app/database/ folder and delete everything there... Then update you db.py connection string to point over the new database server with an empty fresh database and set migrate=True... Run web2py and access your app... Web2py will recreate the whole database... Then you insert your data. Richard On Mon, Feb 22, 2016 at 9:39 PM, Richard Vézina <[email protected] > wrote: > If you restore database like for like, why are you bother with > fake_migrate... Just leave everything to migrate=False should be alright if > you dump contains all the tables... > > Richard > > On Mon, Feb 22, 2016 at 4:55 PM, Brian M <[email protected]> wrote: > >> I seem to have run into a problem with tables I'm using >> _enable_record_versioning() with. I'm setting up on a new computer and have >> restored a DB backup to the new computer. Now when I try to run pages that >> utilize those tables the database is complaining that the _archive tables >> already exist. I've tried >> db.table_name._enable_record_versioning(fake_migrate=True) but that >> argument isn't expected. I've tried using fake_migrate_all=True in the DAL >> connection but that doesn't do it either. So what can I do to get web2py to >> recognize that the archive table is already there and it doesn't need to >> try to recreate it. >> >> Brian >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
