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

[mneuron]

Yes I switched back and succeeded. If it’s worth, is up to you.
The HA developers recommend using SQLite as the DB and made some really spectacular improvements on the performance.
See my ‘manual’ (no guarantee):

Migrating from MySQL (mariaDB) back to sqlite

Because the optimisation by the HA team for SQLite was huge I wanted to switch back from MAriaDB to SQLite… I finally succeeded in switching (back) from MariaDB to SQLite and keeping all states/events and statistics. (I’m on 2023.4.1 , the database scheme is 41 ) I used HeidiSQL, connected to the MariaDB and 1.export (with data: ‘replace existing data’) all seperate tables (only DATA, no table ). [image] change configuration.yaml, recorder: #db_url (now sqlite is the defaultDB) delet…