This is my very frist interaction with this comunity and it goes without saying Im a completely newbie with HA and stuff but having heaps of fun with my new home automation hobby.
I’m running HA on a HABlue, MariaDB and InfluxDB /Grafana for facy graphs with my sensors data.
I run full backup every couple of days and upload them to Google.
Question: is there a way to run partial backup (just for the influxdb data) everyday? Would the partial back for the addon (Influxdbg) backup the data or only the app?
Sorry if question not properly articulated but you probably catch the gist of what I’m trying to do here.
I found similar topics but the info does not suit my configuration (too complicated/overkill)
I’m begining to think the best and simplest way is to run full backups everyday as I’m sure (???) the data will be included.
In that case you just need to deploy an automation which will make a partial backup of just the influxdb addon. When this backup is made, the google drive backup addon will automatically upload that to google drive. Make sure that you have no enabled ignore other backups in google drive addon which is disable by default. The automation should look like this.
Here the automation is triggered at 3 am everyday. You can change it according to your system. If you have any trouble deploying automation please check the below gif.
It appears that the actual data in InfluxDB is being backed up. I downloaded one of my tar snapshot/backups and looked at the contents (pasted below). The size of this folder was 81MB and I’ve only been running InfluxDB for a few weeks.
Note that I did not try restoring this backup to ensure that the backup has integrity. If someone could post if they’ve successfully restored an InfluxDB from HA backup, that would be good info.
I recentlyhad an SSD fail and had to restore from a full backup this week. The data in Influx DID get restored. (I run a Pi 4 with an external disk and no SD card).
I only had a gap from the time of the previous full-backup to when I got a new drive on-line.
Here’s a screen-grab from one of my sensors, showing data from before the drive was replaced.
Can you backup a running influxdb, or does it need to be stopped? I stop it, but I’d rather keep it running so I won’t lose anything during the backup. But I can imagine this is the difference between a successful restore and loss of data.