Thank you guys! I will do a test and let you known. Thank you for now.
Il giorno sabato 9 febbraio 2019 17:47:53 UTC+1, Ben Lawrence ha scritto: > > 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.