On 10/09/2020 21:27, druck wrote:
> 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
>
>
Unlikely to be allowed to connect to DB directly - have to use a web
interface.

Heck I run my own servers and I NEVER expose the mysql server port to
the internet.

Only absolutely specific web pages that update very specific things in a
very defined and validated way.

SQL programming done on the server by a web script custom written for
the job.



--
"When a true genius appears in the world, you may know him by this sign,
that the dunces are all in confederacy against him."

Jonathan Swift.

--- SoupGate-Win32 v1.05