And turn off lazy-tables until mysql has built all the tables. On Friday, February 8, 2019 at 5:03:29 PM UTC-8, 黄祥 wrote: > > - what version of mysql do I have to install to my PC where I have 2.17 >> version of web2py? Where can I find? >> > > in windows env there are mysql and mariadb > *ref:* > https://downloads.mariadb.org > https://dev.mysql.com/downloads/mysql/ > > - is it necessary to install drivers or it is still included in my web2py >> installed by windows installation method? >> > > web2py already ship the mysql driver > > - what is the procedure to migrate the db of my application? >> > > better to export and import in csv file > > *step*: > - create database mysql > - when web2py using sqlite use export_to_csv_file() > - change db uri in private/appconfig.ini from sqlite to mysql > - load web2py app, ensure migrate is true, so that will create the tables > defined in web2py > - when web2py using mysql use import_from_csv_file() > > *ref:* > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Exporting-and-importing-data > > > another way around is web2py have a scripts/cpdb.py > *ref:* > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Copy-data-from-one-db-into-another > > - after migrating, how to install the application using pyrhonanywhere >> site? (I'm just using the app made with SQLite) >> > > *local* > - export your database using mysqldump > - pack your app from web2py admin > > *pythonanywhere* > - login to pythonanywhere, use tab console to import your mysql database > - then in web2py admin just Upload and install packed application > > best regards, > stifan > >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.