I’m using Home Assistant OS on bare metal with an ESP32 through ESPHome, and ESPHome. Sensor data is stored in a MariaDB add-on.
I currently back up the system automatically both locally and to a network share.
At the moment, the database appears to be fully backed up every time. Is there a way to do incremental backups instead, so that only new data since the last backup is saved or transferred?
Basically, I’m trying to avoid backing up the entire database every time and only save the changes.
No this isn’t possible using the HA backup integration. How big is your recorder database?
Maria supports incremental backups.
I don’t use the add-on, I run it in Docker. So you could roll your own backup using standard DBA techniques.
It’s currently around 0.5 GB, but it is expect grow significantly. Are there any recommended alternative methods to back up the database without using the HA backup integration ?
Well there’s the reply directly above yours.
My MariaDB sits around 3GB after using a lot of excludes for data I’m not interested in keeping. Backups have no issue with that.