The issue is that when I connect the app to the mysql and I check the
database administration interface, the tables are all there as expected,
but all the records are missing. The app was uploaded to Pyuthonanywhere
using sftp because Pythonanywhere has a app size limit for the admin
interface upload. In any case, all the records were uploaded, I can run the
app using sqlite but they are not showing up on the mysql.
Any help would be greatly appreciated.
On Monday, August 17, 2015 at 6:50:03 AM UTC+8, 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.
