Check the sections in the book about Migrations ( http://web2py.com/book/default/chapter/06#Migrations) and "Fixing Broken Migrations" ( http://web2py.com/book/default/chapter/06#Fixing-Broken-Migrations). web2py stores migration information for each table in files in the 'databases' folder (so you may need to delete or fix them). Also, if you're expecting some migrations but not seeing them, make sure you don't have 'migrate' set to False. Anthony
On Saturday, March 26, 2011 8:34:29 PM UTC-4, fib wrote: > Hi all > > I am learning the ropes so to speak and am using a remote mysql as a > db > I have sorted out the tables from legacy db to be generated by web2py > along with the auth tables > > I need to know what the quick way is to reset the db - as i learn and > make mistakes > in previous times I would just drop a table and I had assumed from > what I read web2p would find it missing and reinstall / generate > > This is not the case and when i make changes they do not seem to > update the tables > I cannot pack and reinstall because it remembers DB state > > So I end up creating a new simple app and dropping in the files i used > before db.py, default.py and any views etc I have altered > then the system resets and lets me move on > > there must be a better way? > > Thank you in advance for your time > newbie apologies
