srch

17.08.2020 · After restoring HA (on Rpi4) from a full snapshot, logbook no longer works. It just spins indefinitely. There are no pertinent errors in the log. History works fine. Recorder is set to use mariadb in config.yaml. Enabling or disabling the Logbook cache integration does nothing. I tried to delete and reinstall mariadb addon, to no avail. How do I solve this? Thanks.

The supported database solutions are: MariaDB ≥ 10.3; MySQL ≥ 8.0; PostgreSQL ≥ 12; SQLite ≥ 3.31.0. Although SQLAlchemy supports ...

Hi, I used to be able to delete the state history of one sensor from the database, but now that there are foreign key constraints from ...

Hi, through phpadmin, I can connect to the MariaDB database and delete the data of a sensor with this command: DELETE FROM homeassistant ...

Nov 08, 2020 · MARIADB: Automatically delete the data of a single sensor - Configuration - Home Assistant Community. Hi, through phpadmin, I can connect to the MariaDB database and delete the data of a sensor with this command: DELETE FROM homeassistant.states WHERE ʻentity_id` LIKE ‘% sensor.cputemperature%’ LIMIT 250 Would it be po… Hi, through phpadmin, I can connect to the MariaDB database and delete the data of a sensor with this command: DELETE FROM homeassistant.states WHERE ʻentity_id ...

May 17, 2020 · MariaDB 10 has been updated several times since the original post (currently on version 10.3.21) and there have been a number of minor changes which affect the instructions above.

Jan 07, 2019 · The MariaDB addon just runs an instance of MariaDB Server as a separate image that Home Assistant can talk to. You don’t need it if you want to host your DB on a separate server, just change “core-mariadb” in your db_url value in configuration.yaml to the IP address or hostname of your new server.

When you uninstall it should delete the entire database docker container. Maybe it's not the MariaDB addon that is at fault?

29.08.2020 · How do I delete the database on Home assistant? I’m getting “recorder could not start” errors and everything I’ve read tells me I need to delete the database and start over. How do I do that? From what I’ve read I have to ssh to the raspberry pi on port 22222 to do this. I’ve set up and installed the public key and get into the system but where is the database file located? And ...

117 votes, 67 comments. 154K subscribers in the homeassistant community. Home Assistant is open source home automation that puts local ...

I just want to delete it and let the sytem create new one. I know I can do it via config but I find it easier to ssh to my Pi, find db file ...

During the startup, Home Assistant will look for the database specified in the db_url. If the database doesn’t exist, it will not automatically create it for you. Once Home Assistant finds the database, with the right level of permissions, all the required tables will then be automatically created and the data will be populated accordingly.

17.05.2020 · MariaDB 10 has been updated several times since the original post (currently on version 10.3.21) and there have been a number of minor …

I get an ha > prompt. ... and get access to the file system but where is the db located? And… should I stop HA before deleting the db? Can someone ...

keep my DB size from getting out of control (2 weeks of data is ~1GB, don't want that to go to ~25…) I am using MariaDB on a different ...

This should switch you back to using the default SQL db. Add back the addon and uncomment the db_url and restart again. Delete the home- ...

08.11.2020 · Hi, through phpadmin, I can connect to the MariaDB database and delete the data of a sensor with this command: DELETE FROM homeassistant.states WHERE ʻentity_id` LIKE ‘% sensor.cputemperature%’ LIMIT 250 Would it be po…

Aug 29, 2020 · Fixing Home Assistant DataBase Problems With MariaDB Addon. In this video I replace my overloaded Home Assistant Internal Database (SQLite) with MariaDB. MariaDB is an implementation of MySQL that can handle a lot more data a lot more efficiently than SQLite.

A good way to tell is for you to look at your ‘home-assistant_v2. db’ file. If it is over 800mb, you are a candidate to replace the internal database with MariaDB Addon or some other external database. Update as of Home Assistant 2021.7 version. If using @ inside your db_url as I did below, the @ sign now needs to be represented as %40 .

Using MariaDB and the database has now grown passing 9 Gb. I've added some exludes to recoder: recorder: db_url: !secret urlMariaDB ...

A good way to tell is for you to look at your ‘home-assistant_v2. db’ file. If it is over 800mb, you are a candidate to replace the internal database with MariaDB Addon or some other external database. Update as of Home Assistant 2021.7 version. If using @ inside your db_url as I did below, the @ sign now needs to be represented as %40 .