mardi 28 juillet 2015

Need help uploading data from SQLITE db on Arduino Yun to MYSQL db on webhost

First off, my knowledge of web related coding is a 5 on a scale from 1 to 100. My python and sql language skills are better but I am by no means an expert in either.

The task: I want to dump a sqlite database of a few thousand records once a day to a MySQL database on my private domain that is running MySQL.

Question: I know the Arduino side can NOT handle this task efficiently, but the linux side should be able to using Python scripts.
1) What do I need on the Arduino/Linux side to make the connection with the web host? {code examples or link to tutorials would be great} 2) What is the syntax that would transfer several rows of data once the connections is made 3) What do I need on the web server to accept the data from the Arduino and insert into the MySQL db?

I have googled this topic for help, but either I am not asking the right questions or the method is more complicated than I understand at this point.

Any help or direction as to where or how to learn this is greatly appreciated.

Thanks a bunch in advance!

Aucun commentaire:

Enregistrer un commentaire