So I have the following mysql.persist but I don’t see anything shown in HABmin. How can I assert if MySQL persistence is working?
Strategies {
everyMinute : "0 * * * * ?"
everyHour : "0 0 * * * ?"
everyDay : "0 0 0 * * ?"
default = everyChange
}
Items {
gSQL* : strategy = everyChange, everyHour, everyDay, restoreOnStartup
}
Here’s what I have in my openhab.cfg:
# the database url like 'jdbc:mysql://<host>:<port>/<database>' (without quotes)
mysql:url=jdbc:mysql://192.168.1.130:3306/openhab
# the database user
mysql:user=openhab
# the database password
mysql:password=openhab
Is there somewhere these persistences are saved and how to check it? something like show databases; etc