Deleting old persistence after years of abandonend items

Setup, Configuration and Use Runtime
1

I’m wondering on a simple way to delete old persistence, which is not needed anymore.
So I’m running openHAB for more than a decade and mostly on a mysql/mariadb persistence.
over the years I renamed, deleted or otherwise got rid of items. So the database consists of quite a few tables of items, which are no longer there.

is there a simple way of deleting old persistence? or do I need to manually check current items and truncate (or delete?) those tables, which are no longer needed?

2

yes, for jdbc there are maintenance commands:

1 Like
3

oh great! Thanks!
jdbc tables clean is only deleting tables, which are empty, but you could use “force” for specific items then.