Delete all historical sensor data (while keeping sensors) Topic is solved
Moderators: leecollings, remb0
-
- Posts: 32
- Joined: Monday 18 May 2015 17:12
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Location: United Kingdom
- Contact:
Delete all historical sensor data (while keeping sensors)
I've been messing around a lot with a Domoticz build the last few days, and I've now come to a point where I'm quite happy with how it works. The only problem is that many of the sensors have completely invalid historical data, including wildly incorrect values, and I would like to "wipe the slate" clean and restart the log. Is there an easy way to do this, without deleting (and recreating) all the sensors?
-
- Posts: 104
- Joined: Tuesday 08 November 2016 14:03
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Location: Poland
- Contact:
Re: Delete all historical sensor data (while keeping sensors)
You can open database and delete not necessary data
HW:Raspberry PiB+,Pi3,PiB,RFLink,FA20RF,DCS-930L,DCS-935L,Clarus switches,RF Temp sensors,Owl Micro+,Mi Flora,Kerui,Yeelight,Xiaomi,Broadlink RMM3,Alexa
SF:Jessie,Dmtcz 3.8153,Logitech Media srv,PiCorePlayers,Dashticz,Max2Play,InfluxDB,Grafana,HABridge
SF:Jessie,Dmtcz 3.8153,Logitech Media srv,PiCorePlayers,Dashticz,Max2Play,InfluxDB,Grafana,HABridge
-
- Posts: 32
- Joined: Monday 18 May 2015 17:12
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Location: United Kingdom
- Contact:
Re: Delete all historical sensor data (while keeping sensors)
Allrighty, I'll have a poke around with sqlite3 - after stopping Domoticz, and making a backup copy...
Who is online
Users browsing this forum: No registered users and 1 guest