Hello, if I trye to install mysql 8 on my windows pc it tells me I have a problem about requirements. I don't have installed python 3.7. But could I have problem installing python 3.7 on my web2py based on python 2.17? thank you in advance for your gently answers!
Il giorno sabato 9 febbraio 2019 20:40:25 UTC+1, Andrea Fae' ha scritto: > > 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.