back-up domoticz.db to a mysq db

User avatar
Egregius
Posts: 2667
Joined: Thursday 09 April 2015 12:19
Target OS: Linux
Domoticz version: Beta
Location: Beitem, BE
Contact:

Re: back-up domoticz.db to a mysq db

Post by Egregius » Friday 11 May 2018 13:40

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
Posts: 17
Joined: Saturday 24 February 2018 14:43
Target OS: NAS (Synology & others)
Domoticz version: v3.8153
Location: NL
Contact:

Re: back-up domoticz.db to a mysq db

Post by JoeneH » Friday 11 May 2018 17:27

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

User avatar
Egregius
Posts: 2667
Joined: Thursday 09 April 2015 12:19
Target OS: Linux
Domoticz version: Beta
Location: Beitem, BE
Contact:

Re: back-up domoticz.db to a mysq db

Post by Egregius » Friday 11 May 2018 21:53

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 ;)

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest