If you want to delete all tablesand recreate them, you can : * (be aware that you will lose all your data) *
- Delete all your tables on MySQL (it would be a good idea to make a backup of your data before...) - Delete all files in *YourApplication/databases *folder - Launch your application : all tables will be recreated empty Le vendredi 31 mai 2013 18:18:38 UTC+2, André Kablu a écrit : > > Hi all, > > I am creating a new app using MYSQL... and many times I needed to change > the fields, including keys, foreign keys, etc... > > And I always get many mysql errors of not possible to rename, not possible > to delete, not possible to create, etc... > > So what I need to do is to copy all my files to another project, delete > the base manually and then recreate it in the new project... > > When I erase manually all tables, web2py says that "TABLE DOES NOT EXIST!" > when trying to load app and do not recreate them... > > Is there a way to recreate all tables, include auth, etc... without > needing to create a new application or having to migrate from somewhere? > > I understand that if I erase the db model... reload the application, and > then put db model again, reload app again, it will recreate all model > tables... is that correct?? > > Thanks all! > > > -- --- 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/groups/opt_out.
