Advise on posting large datasets to MySQL

I am looking for advise on how to revise my current setup such that it works with the Adafruit FONA cellular module. I have posted on Adafruit's forum but thought I'd post here too.

The challenge is to post a large data set, several hundred records at a time to an online MySQl database using a cellular card connected to an arduino.

My current setup is this: I have a Yun that collects data from several Arduino based sensors and logs that data to a sqlite database. Data is logged at a resolution of ever six seconds. Periodically a python script runs a query on the database building a json string of several hundred records and Posts that data using requests.post to a PHP file on a web server. The code is below for both python and php as an example. This methods works fine when I have wifi or ethernet connections.

My Challenge is how do I convert this setup to use the FONA? Options I am considering include: FTP or similar .csv file to server and tell PHP script to open file; read json string from text file and post using a streaming method; other solutions?

The challenge is to post a large data set, several hundred records at a time to an online MySQl database using a cellular card connected to an arduino.

As I understand you need sim card (internet connection) module, I got that on my future projects,
I don't have any experience with sim card modules but I know that sim900 can use a sim card
and activate internet connection, after that you need to play with the http:// and uploading data to your
host website myadmin DataBase.

Try to search on google (key words):
Sim900 php database upload
sim900 sim card internet connection
sim900 http data upload to a host website database

..etc

I've seen only few tutorials, if you understand how to work with php and database on a web host or your
own website then try to view few tutorials about how to connect/set up the sim card online and how to work with the http and uploading data.

D.60

The FONA module is a SIM800. My issue isn't with sending a single record to the web server. That is easy; build a json string for a single record and pass it to PHP file on the server. The problem is when you try to build a json string with several hundred records. The RAM on the arduino can't handle such a large string.

Try to reduce the string and cut it in several segments and reduce the speed if the ram can't handle
large data in short time.

Can you tell me what kind of records do you have (an example not real data) how many data, strings and
how you arrange them in the batabase. Give me some info maybe i got some ideas and fix the problem.

How fast do you want to upload the data?
Is the data from several sensors 200ms 1000ms of data per sensor how exactly?
How you store the data or you try to send them directly?