I corrupted my web2py -myql mapping and am trying to rebuild the web2py
database files from scratch.
Starting point:
- The mysql database tables already exist. Some tables were working
correctly under the old mapping, and some were never mapped.
- I've already deleted everything from the databases folder.
- I've already cleared everything from the db.py file except the
original code (auth tables, etc.)
Plan:
- Set migrate=False, fake_migrate_all=True at the DAL connection level:
db = DAL('mysql://root:root@localhost/mydb', migrate=False,fake_migrate_all
=True)
- Re-add each table into the db.py file one by one, starting with a
fake_migrate and then going to real migrate into all the tables were
working.
Problem:
- I can't get any table files generated for anything, even the auth
files. Setting fake_migrate_all=True doesn't generate any files, and
setting migrate=True gives me an error that the tables already exist.
How do I get the table files to generate?