Persistence Maintenance

[JensH]

@olialb

This script goes over all data base tables and link them with the actual items in openhab

I yesterday did it with a mix of mysql Procedure and an openhab-rule!

Published here:

"Garbage Collection" on MySQL persistence: deleting old Item states

Part One: Deleting Old Values Based on examples in this Thread I put all hints and further usefull things together: If you want to cleanup Old Item-Data all code can be send directly in SQL-Database. For jdbc-mysql-persistence all Commands have to be send in SQL (for example in SQL Window in phpmyadmin). has to be changed to your exact table name, you can see in phpmyadmin. Following Examples are tested with OH 2.5 SNAPSHOT 1680: 1.1) Alter Table for Items to set maximal history of data as l…