okay I will do so. Also, the error is ProgrammingError: (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option CHAR(1),\n size CHAR(1),\n is_active CHAR(1),\n created_on DATETIME' at line 16")
On Tue, Apr 3, 2012 at 1:34 PM, Richard Vézina <ml.richard.vez...@gmail.com>wrote: > Change your db connection string to the mysql server then > > fake_migrate=True > > And > > get back with migrate=True. > > Search the book with fake_migrate for more explanation. > > Richard > > > On Tue, Apr 3, 2012 at 4:26 PM, Kenny <nis...@gmail.com> wrote: > >> I inserted databases on Fluexflex's MySql. However, I had an error while >> inserting them. >> >> The question is how can I delete SQL file in web2py application and >> insert dbs all over again? >> >> I dropped all the tables in mysql server. However web2py application has >> sql file that I cannot have an access in Fluexflex. >> >> So, I can't let DAL insert dbs automatically since DAL assumes that the >> tables are already created. >> >> Any help would be appreciated. >> >> Thank you. >> > >