Database backup

Hi all,

I was wondering if you use the sudo openhabian-config if the persistance database is also included in the backup file?

If not, where is the database located, such that I can make a manual copy?

Thank you,


Which database? If it’s MapDB or rrd4j I think it does. If an external database server like InfluxDB, you have to back those up separately. They are not part of openHAB so they don’t get backed up as a part of openHAB. It’s best to look at the docs for the database in use for backup and restore instructions.

I have this in jdbc.cfg: url=jdbc:mysql://
So that would make it mysql. I do see some files in /var/lib/mysql im guessing its stored there?

Then you need to go look up instructions to backup and restore MySQL. For databases it’s rarely enough to just grab a folder.

Alright, thank you for your guidance!

Ok I found the answer, let me share that in case somebody else has the same question:

sudo mysqldump -p --all-databases > /var/lib/openhab/backups/all_databases.sql