On 15 Mar 2013, at 3:44 PM, Martín Mulone <[email protected]> wrote:
> In my experience recently I had many problems with pymysql, so I switch to
> mysqldb using dal.
>
>
I'll give it a try. A question, though. The book suggests:
> from gluon.dal import MySQLAdapter
> MySQLAdapter.driver = mysqldb
But just what is the symbol mysqldb? And how does it relate to the driver names
in gluon.dal?
> import MySQLdb
> DRIVERS.append('MySQL(MySQLdb)')
...
> class MySQLAdapter(BaseAdapter):
> drivers = ('MySQLdb','pymysql')
> El 15/03/2013 13:18, "Jonathan Lundell" <[email protected]> escribió:
> On 15 Mar 2013, at 8:15 AM, Niphlod <[email protected]> wrote:
>> you could set some filters and with the frid it should export only the
>> records shown, not the whole table....
>
> I think I'll write a script to parse the database dump into a csv file
> instead; it's a lot quicker.
>
> But this seems like a bug to me: at least in the admin app, a table export
> ought to Just Work; it's pretty trivial, after all, even if it's large.
>
>>
>> PS: passing driver_args = {} should do the job with pymysql, but I don't see
>> any forums showing that that kind of error is driver-dependant on some kind
>> of timeout parameter (as is in sqlite).... seems a mysql configuration
>> directive (meaning my.cnf, mysql.ini, etc)...
>>
>> wait_timeout =
>> connect_timeout =
>> or more probably
>> net_read_timeout
>>
>> cfr. http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html
>>
--
---
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/groups/opt_out.
