You could open a connection to both databases then copy the data over that
way. That's what my day job is, transferring data, ETL.
On Sunday, August 23, 2015 at 7:49:12 PM UTC-7, Joe wrote:
>
> 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.
