No More History Loss In Home Assistant!

The standard recorder in Home Assistant sometimes gets corrupt and results in losing your history and Home Assistant not starting up again. You can solve this by using MariaDB to record the history of your sensors. This short tutorial shows you how to set this up in minutes so that you will never lose your history and Home Assistant does not fail in booting anymore.

⭐⭐⭐
I cannot do this without your support!
If my videos save you time, you can support me in the following ways:

⭐⭐⭐

See the list of Smart Home devices that I use and recommend here:

If you got enthusiastic about Home Assistant, you can watch these videos too:

Background music composed and produced by Smart Home Junkie

Contents:
0:00 Introduction
0:21 General description
0:34 Install MariaDB
0:59 Configure MariaDB
4:00 Restart Home Assistant

#homeassistant #homeautomation #iot #smarthome

[kpurintun]

your video's always teach me something new in yaml. Usually something to help me organize my stuff and just make it easier. Today, it was the secrets stuff at 2:40. My Config.yaml and the like has never been so clean and organized, and now its safer to share screenshots. thanks!

[djmattc]

Thanks for this! How do I get rid of the old database file, wherever that is?

[JasperWaale]

At 2:30, you show on screen that you will put, I guess, the text, etc., in the description, but I don't find them. Also, I'm curious about your entries list. Did you manually find the names or do you have output you're able to copy from?

[Mpgod]

Hi there. I want to go back from Maria DB to standard Home assistant SQL database. Can you plz make a tutorial how to do that in your great way of explaining and showing. 😊

[janus]

Hi thanks for the interesting videos, but I have a question, do you also need to make a extra db if you use the InfluxDB?

[brine]

what does your updater domain do / how did you get it?
if i list my domains using {{ states | groupby('domain') | map(attribute='0') | list | join('\n') }} i only get an update domain.
Im just curious because i am a noobie and dont know what is good practice to include

[okanerdem]

Could you please share your Door sensors and Motion sensors YAML code? Looks like great! battery, trigged and status can see in the same page

[crabsodyinblue]

is it possible to use an external mariadb url, like i have mariadb running on my NAS, would feel better use that one, to create the history backup away from the ssd-disk the HA is running on.

[beltmana]

Thanks for great video. I followed the instructions and all worked fine except for one thing. I lost all my Energy Dashboard history. Is there any way of getting that info back into MariaDB? Copying/restoring data from the original home-assistant_v2.db?

[MrPeterVanHees]

Thank you. 👍 I've implemented this on my Home Assistant. 🚀 As I'm new to Home Assistant (and have yet to setup sensors), I don't know how to validate that it's working. 🤔 I checked the Mario DB log, but I guess that is not telling me if Home Assistant is using the datbase now.

[jordanadam]

Hi
You can record guide how to extend standard history logs from 10 days, this is what i was looking for here :)

[DroneWorldWonders]

Hello thank you for the video, but i have a question. Why should we use mariadb instead of sqlite database? What’s the advantages? Thanks in advance

[mijnnet]

Hoi, heb jij een handige tip om log data op te schonen? En, kan ik voor bepaalde entities ook de geschiedenis verwijderen? Niet van alle, dus ik wil zelf bepalen welke wel/niet en voor welke periode. Je hulp is welkom.

[sevagjb]

thanks to this helpful video mi wondering if i can make my db size smaller currently my backup size is 1.5G

[DeVosjes]

Gefeliciteerd met deze duidelijke video, heb alles zonder problemen kunnen installeren.
Mijn vraag is of het intussen bekend is waar de database-file van maria-db zich bevind ?
Kwestie van bij het terug plaatsen van een snapshot deze er zeker bij is.
Alvast dank en You're doing a great job.

[djihfhoewang]

Hallo,
Mooi duidelijk filmpje
Maar krijg meteen al een fout melding.
commit_interval: 30
Als ik die weghaal dan wordt de volgende regel als foutief aan gemerkt.

Heeft het misschien met mijn nieuwste versie te maken?

[Marcel_Brouwer]

Top uitleg, super simpel om trends op te slaan en te kunnen volgen

[shaunwhiteley]

Thanks, question please, where is the mariadb file saved! In /Config

Just in case I wanted to do a fresh install but still retain all my history.

Also does graffana look at this db or home assistant normal database ( forget what it’s called just now. ). Cheers

[lincongkai]

i see at 1:01, you opened up addons configuration with 'edit in YAML' by default. mine is always in UI. i need to 3 dot > edit in YAML. How do you make open in YAML default? Thanks!

[MauricioReyno]

how long it collect data? it purged sometime and delete old records?