If you start using InfluxDB to store your data (for example to get great charts with Grafana ) you might want to migrate your old data from the “old” persistance service (like rrd4j) to the new database. Otherwise our new charts would only start from the time you started using InflluxDB. So here is…

@ThomDietrich , should this be linked to from the OP for InfluxDB+Grafana Tutorial? More people may want to switch if they know they now have an easy way to migrate their data out of whatever they are using now and into InfluxDB.

Good call, I would maybe have missed it. @christoph_wempe this is a great help. I’ve linked the tool in the InfluxDB+Grafana article: InfluxDB+Grafana persistence and graphing

Fantastic. Fear of losing old data had made me stick to rrd4j. The other thing that stops me moving is concern that InfluxDB databases may spiral to enormous size - I used to have that with db4o before I moved everything to rrd4j. Is there a neat way of purging old records from InfluxDB? thanks D…

I think you could write a script and use the DELETE-SQL command to delete entries older than X. [image] InfluxDB+Grafana persistence and graphing Tutorials & Examples Store your openHAB item states in an InfluxDB time-series datastore and create highly customiz…

[image] dan12345: Is there a neat way of purging old records from InfluxDB? You can configure a retention policy that will automatically purge data as it ages. Also, InfluxDB does a MUCH better job of handling large databases. And in practice I see between 1-6 mb per Item per year which isn’…

It looks like the script is not working with openhab 2.1. :disappointed: The Rest interface does now return a single line of data rather than multiple lines. I will look into it tomorrow. :sleeping:

The latest version of the script supports switch items. The previous one did not, because ON/OFF had to be translatet to 1/0. I also created a branch for openhab 2.1 compatibility. GitHub - CWempe/rest2influxdb at OH21 OH21 Contribute to CWempe/rest2influxdb development by creating …

Great CWempe! Thanks for the contribution and the update for oh 2.1. Will certainly use this as a) I enjoy grafana/influx very much and b) I am a data geek. But first I need to get some other stuff going in openhab.

Thanks a lot for the script - with its help I’ve managed to migrate all my data from rrd4j to InfluxDB in OH 2.1. A couple of small changes make the script work as expected: All of the date formats need to be changed to: tenyearsago=`date +“%Y-%m-%dT%H:%M:%S.%3NZ” --date=“10 years ago” And so o…

Migrate your existing persistence data to InfluxDB

Tutorials & Examples

christoph_wempe (Christoph Wempe) June 30, 2017, 1:44pm 5

I think you could write a script and use the DELETE-SQL command to delete entries older than X.

But I cannot imagine database size will be a problem.
Then again, I have no experience in this topic.