back-up domoticz.db to a mysq db

[Egregius]

You can change the domoticz url to http://user:pass@ip:port etc to add authentication.
Add the curl command to the Syno scheduler and your database will be always up to date.

[JoeneH]

Adding the ip address or range to the domoticz exclusion list works for the curl command.

I just read up on adding the curl command to the syno scheduler, before I saw your post: also works.

And in the meantime I managed to view graphs of the data stored into the mysql database in Grafana (running the Grafana server on my windows desktop).

All happy today! And another big thank you for your help.


Coming up:
modifying the php script, I don't need the month data, so figuring out which part to //

waiting for my smart meter to be installed
Getting p1 data into domoticz
Understanding the php script in more detail so I can add other devices (non temp)
Backing up history of p1 data into mysql

[Egregius]

I would keep the data in the month table. In my test it was less than 16KB for 1 month and 7 thermometers. That won't fill your nas

[JoeneH]

Update:
waiting for my smart meter to be installed - Done
Getting p1 data into domoticz - Done
Understanding the php script in more detail so I can add other devices (non temp) - Not done
Backing up history of p1 data into mysql - Not done

What I don't understand from your temp2sql script is how does it know which data to read. My tempsensors log temp and humidity, but the temp2sql only puts the temp values into the database. How does it differentiate between temp values and humidity values in the domoticz database?

The p1 data is stored differently from temp data off course.
Electricity has 6 columns of data, called Value1 to Value6, so how do I get the script adjusted so it reads the correct column? The p1 data for electricity use is split in two (low tariff and high tariff), so I need both of them.

Also the p1 data for electricity use is collected (and stored?) every 5 seconds. Does the script store the 5 sec data or just the 5 min data as shown in the log-file from domoticz?