That sounds like you are connecting to the database, you're just not seeing
the data you expect. How did you transfer the data from sqlite to MySQL?
On Tuesday, 18 August 2015 10:14:54 UTC+1, Joe wrote:
>
> Hi Glenn, Yes, that's me.
> Of course, I would be happy if you could help me out here as well!
> Thanks very much, I appreciate it!
>
> On Tuesday, August 18, 2015 at 4:56:54 PM UTC+8, Glenn Jones wrote:
>>
>> Hi Joe,
>>
>> PythonAnywhere dev here (glenn on the Forums). Are you the guy I was
>> talking to in the forum thread titled "Web2py app connecting to mysql
>> database"? If you are, do you mind if I chime in to this with some of the
>> details we worked out to give the web2py guys a little more to work on?
>>
>> On Sunday, 16 August 2015 23:50:03 UTC+1, Massimo Di Pierro wrote:
>>>
>>> I would talk to them. They are very supporting. Anyway that said. You
>>> can use any hosting you want. I use Python Anywhere, Digital Ocean, Google
>>> App Engine, and Google Managed VM (with Docker) for different projects.
>>>
>>> On Sunday, 16 August 2015 15:43:21 UTC-5, DaneW wrote:
>>>>
>>>> I've been using PythonAnywhere happily for over 2 years. The database
>>>> (now with over 12m records) has worked perfectly under SQLite and later
>>>> MySQL - although I do get error 1226 about exceeding max_user_connections
>>>> every so often.
>>>>
>>>> In the db.py model I have db =
>>>> DAL('mysql://aaa:[email protected]/ccc$db1',pool_size=0,lazy_tables=True,check_reserved=['all'])
>>>>
>>>> - where aaa is my user name, bbb is my MySQL password and ccc$db1 is my
>>>> database name.
>>>>
>>>> I used to have pool_size=1 but in the light of Annet's suggestion I've
>>>> changed it to 0 and it seems to be working ok. Also PythonAnywhere are
>>>> saying that recent infrastructure changes mean that we should alter
>>>> mysql.server to *yourusername*.mysql.pythonanywhere-services.com but
>>>> that results in my website crashing immediately so I've left it as it used
>>>> to be for the time being.
>>>>
>>>>
>>>>>
>>>>>
--
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.
