> > - 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.