Hi, I have defined my auth_tables in a mysql file along with some initial row for my app. The name of this file is '*dump.sql*'. I have renamed the tables, for example auth_users is changed to t_auth_users, similarly the other auth_tables too.
So when the app is hosted the db is created from this file. In the db.py file before the db.define_tables(), i have renamed the auth_tables, for example: *auth.settings.table_user_name = 't_auth_users' * and similarly others too. My question is how to efficiently handle this migration. I cannot get my auth tables modified according to the defintion in the dump.sql file. Instead the table is created with default fields only. I have around 20 fields for the t_auth_users table in dump.sql but only the 9 defaults fields can be seen in webp2y shell db.t_auth_users command. this is the order: 1. First I clear all the files in databases folder for a fresh start. 2. Then load the dump.sql file into the database '*tv*' 3. in db.py *db = DAL('mysql://root:root@localhost/trustvouch', migrate=True) * * * * auth.settings.table_user_name = 't_auth_users'* * * * **auth.define_tables(username=True, migrate=True)* 4. It give me this error, * <class '_mysql_exceptions.OperationalError'> (1050, "Table 'tv_auth_users' already exists")* * * * * Can you help how to get the correct migration of the tables. What I actually need to do is load my table definitions from another mysql dump file , use the tables defined there as my auth tables. * * -- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.