Take a look here http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings--the-uri-parameter-
Then, for MySQL, change the localhost in the connectstring to the name of your database server. You also have to make sure that MySQL is set to allow remote connections from the user you are connecting with. Check out this link on how to do that: http://stackoverflow.com/questions/23733734/how-to-enable-remote-access-of-mysql-in-centos -Jim On Tuesday, April 4, 2017 at 8:07:55 AM UTC-5, Áureo Dias Neto wrote: > > How to migrate data from sqlite to mysql or postgre? > I tried to migrate the data to mysql using the workbench, but it did not > work .. > > And, how would this question the database on another server? How does the > connection work? > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
