JDBC persistance cleanup on mysql db

Add-ons Persistence Services
1

Silly question, and probably an easy answer. I’ve been gradually cleaning up my OH4.3.3 installation partly to get ready for OH5 and partly just for hygiene. I’ve used JDBC persistence with a mariadb instance on a NAS for some time and it’s full of a bunch of junk I no longer need. I’ve already setup item persistence via the gui in 4.3.3 the way I want it, so I’m looking to cleanup the database itself.

Given that I don’t want to save any data, is it as simple as deleting the database and restarting OH to create a fresh db? Or is there another recommended approach?

Cheers

2

You can find some maintenance functions here:

In my setup (Docker & MariaDB 10.5) some of them work, others won’t work …

Hope this helps …

3

An additional option is to use the API Explorer, for example to delete data in a given time range:

jdbc_api
jdbc_api763×350 24.6 KB

4

Thx. But is it possible to simply delete the database and start over from scratch?

5