Recently installed and setup influxdb with Grafana on my Rpi 3+, running Hass.io.
In order to prevent the database clogging my Pi, I am looking for a way to download the database from influxdb, so I can store it on my laptop (which is not always-on) - thereby only having maybe a month or two of data on my Rpi.
My issue is: Where and how do I find the database when running hass.io?
I have installed Portainer and am able to download an image of the influxdb-addon, but have no idea how to go from there.
On Home Assistant Supervised (previously known as hassio on generic linux), the database is in
/usr/share/hassio/addons/data/a0d7b954_influxdb/influxdb
I didnât, sorry. But the size of my database hasnât changed much, if at all, for a long time, so clogging might not be such a big problem as I feared.
However, Iâm still considering upgrading from an sd-card to an ssd-hdd, just in case.
How do you guys find out the location of this? I just installed 110.1 supervised on a NUC and I need to put my old influxdb database in the new location, but I donât have a âhassioâ directory in /usr/share/
Did you ever finde the location of the influxdb.
Iâm trying the same. My âaddonsâ dir is also empty despite having influxdb (and other addons) running.
Unfortunately not. I didnât find out how to transfer my old influxdb to my new NUC HA installation, so I just kept it running on the old machine, now only serving as an influxdb-server⌠Not ideal. Influxdb feels a bit like a black box if youâre not good at it. Kind of worrying for long-term data storage, but I donât know what alternatives there areâŚ
From a Terminal session / SSH, you can run this command
docker exec -it addon_a0d7b954_influxdb /bin/bash
This takes you inside the docker that runs influxdb.
In the folder /data/influxdb you have the database - seems to contain three folders
/data = containing the database itself.
/wal = seems to be work area for the database, before commit or something.
/meta = not sure what that is.
Btw. if you execute âdocker statsâ it will display all running dockers - here you can see the ânameâ of your docker influxdb. Iâm assuming it is the same as mine.
No, havenât tried mysself.
My plan was to move the influx db away from the sd-card and onto a USB attached SSD.
But havenât gotten to that part yet.
I am trying to do that same. All of the other documentation I can find says that it is in /usr/share/hassio/âŚ, but that is not true in my case, where the HA OS is running. Instead, influxdb is installed as docker, and it is where @Soren_Birkholm_Eriks says that it is. I could not get there by command line, as he writes. It says that I have protection mode enabled, which is not true, either. I can find the location by using Portainer, opening the influxdb container, and using Console. It is indeed in /data/influxdb. Portainer shows that it is a mapped volume from /mnt/data/supervisor/addons/data/a0d7b954_influxdb.
I have mounted a network drive using the following