On 10/09/2020 17:22, NY wrote:
> Yes the only bit I haven't cracked is running a process on the Pi that
> uploads data to the web server (maybe in daily batches, maybe every 10
> minutes when a new entry is added to the local log file on the Pi) so as to
> add it to the SQL table. Doing it manually is easy enough from cPanel
> accessed by web page (LOAD DATA INFILE from a file on the Pi or Windows
> PC)

Ah so the database is on the web server. You will have find out what the
database is (e.g. MySql), the IP address, and the username and password
to log on to it. You can then use a suitable Python package such as
myslq-connector-python which can use that information to get a cursor on
to the db. Its then a case of issuing sql commands, in the same way as
for a local SQL db.

---druck

--- SoupGate-Win32 v1.05