WTH: Migrate history when enabling Recorder

[RMoRobert]

@jamesmyatt

If using the MariaDB addon is the “recommended” way as opposed to the default “SQLite” one

It isn’t; the default SQLite database is the recommendation according to the docs:

There are community-documented methods of migration, if that is still helpful. Here’s one I could find, though there may be more:

Migrating home assistant database from sqlite to mariadb.. ONLY if you are VERY familiar with Database administration

As requested by @jr3us, here is an updated script up till today. It might become obsolete as new versions are created and might not work for you! I offer absolute NO guarantee for any data lost!. You are warned. # The first few steps here are typical install and configuration of mariadb. sudo apt install mariadb-server mariadb-client sudo apt install libmariadb-dev sqlite3 sudo mysql_secure_installation I did the following 2 steps using phpmyadmin Created a user hass with all permissions …

Whether migration can or should be built-in is something I can’t answer, and I do know some people claim better performance (for things like viewing history, at least) with another database engine. But, at least, I don’t see any official recommendation not to use the default.