#INSTALL SQLITE STUDIO UBUNTU 20.04 HOW TO#
#INSTALL SQLITE STUDIO UBUNTU 20.04 INSTALL#

I coppied my database into working directory (home-assistant_v2.db) and executed:.I placed file “influxdb.yaml” into my working directory, file contents:.I followed all instructions and it looks like all dependencies are installed (I’m doing this on arch linux).Hey, I’m having some trouble trying to make it work, do you know what I’m doing wrong? If someone coming over this will find a solution to adjust the script for SQLite as source DB I´ll happy to hear (I kept a copy before pruning and repacking it ). Update: After investing/wasting a few hours in total on this, I tend to just forget about that history data, unfortunately.

#INSTALL SQLITE STUDIO UBUNTU 20.04 HOW TO#

Because: I know what I want to achieve, I have the tool for that right in front of me, but I don´t know how to (adjust and) use it. I spent some time (few hours already) but ended up in being just frustrated. The script provided by is probably the best start. Adjust the script to work with SQLite instead of MySQLĪs this topic initially was about SQLite as source database I´m very interested in a solution for exactly this.Understand how to setup the necessary steps to run the script (any linux machine okay?).I have SQLite database and InfluxDB (as add-on/container managed by Supervisor) running in HASS OS on the same machine and trying to figure out how to run that script… Linux would be no problem, current problems are: Or how would I point to the SQLite database?

#INSTALL SQLITE STUDIO UBUNTU 20.04 INSTALL#

Thanks for that !!! - I was looking for something exactly for that purpose - migrating data from SQLite to InfluxDB before the InfluxDB has been integrated into HA.Īs far as I can see according to this script needs to have HA running on a full Linux machine in order to do the setup, install dependencies etc., right? I was very lucky to find this thread after I realized this one was for openHAB instead of Home Assistant. Thanks for the script, worked like a charm apart from the little hickups Added that and refined the readme a bit, the requirement installation was out of order wheel is defined in the requirements.txt, but is already needed in the requirements.txt of Home Assistant. Just went ahead and tried it needed to make some changes though because I’m using MariaDB that’s listening on port 3307. I did not yet do this step so should I first restart HA with this configuration so it creates some tables in the home_assistant db in influxdb or can I just start using influxdb and merge later will the script detect duplicate entries?

Should i just add an empty influxdb.yaml? I do not (yet) have any security on my new InfluxDB docker image, so I was going to enter just this in the HA configuration.yaml. Thanks! Just a few small questions as I’m just installing influxdb and have soms 180K records in my MariaDB installation I want do do it right in one go.

Install sqlite studio ubuntu 20.04