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

Reply via email to