Yes, now I can connect but I wasn't able to connect before. First, I
couldn't upload the packaged app using the admin interface because I didn't
know about PythonAnywhere's app size upload limit. Then, after I uploaded
the app using sftp I was getting the error messages every time I tried a
new code to connect to mysql. I don't have a lot of experience, I learn as
I go.
Now, that I can connect to mysql, I tried a couple of different things to
transfer/migrate the data but I don't know enough to make it work. The data
is videos and images so I can't use a CSV file to transfer it and
migrating the records one table at the time to rebuild meta data is way
over my head. However, now at least I can connect to the database so what I
have to do is to insert all the records again manually to the mysql.
Thanks for your help and please kindly understand that because I am just
learning this process, I often need a bit more support than the experienced
developers.
Thanks again.
Cheers,
Joe
On Tuesday, August 18, 2015 at 8:52:24 PM UTC+8, Glenn Jones wrote:
>
> 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.
