I’m using OH2b4 and want to clean my database (mysql).
Up to now I’ve been playing with the persistence mode (everyMinute, everyChange and others) but decided now to store everyMinute.
Therefore I want to whipe out all ‘old’ data in my database but NOT the items as in my *.items list.
OK, there are two databases. There is the one that OH 2 uses to store configuration and persistence. running smarthome:items clear only clears out the OH 2 configuration database.
In MySQL you probably should just drop the DB and let OH 2 recreate it.
Managing the actual persistence databases is beyond the scope of what OH 2 manages. You have to do that yourself.
One note I will make is the config DB changes so when you upgrade you will likely need to reinstall your bindings and reconfigure everything.