Migrate database from SQLITE to MariaDB (With full history)
DO IT ON YOUR OWN RISK! You have been warned This is step by step guide, how to migrate Home Assistant default SQLITE database to MariaDB . I have tried also sqlite3-to-mysql mentioned here: Migrating home assistant database from sqlite to mariadb.. ONLY if you are VERY familiar with Database administration - Share your Projects! - Home Assistant Community but in my case it didn't work (history was corrupted) I did it on the latest version of HA 2025.9.1 0. required DBeaver community 👉 download database knowledges :) I won't write exact SQL scripts here for empty DB table and so. 1. BACKUP!!! 2. stop HA core From home assistant console (not from web, but directly on PC/virtual machine) run 'core stop' 3. backup home-assistant_v2.db from directory config backup home-assistant_v2.db database and copy it somewhere to windows machine, where it will be accessible to installed DBeaver This snapshot will be restored to MariaDB 4.Install MariaDB Install M...