How to revert from MariaDB to HA DB?

[AleXSR700 (Alex)]

Hey everyone,
I have gotten used to MariaDB and the easy access using phpMyAdmin but qith the improvements ongoing I would like to revert to the built-in database.

However, I have around 5 GB of data collected over the last 12 months and do not want to lose it.

Is there a way to safely transfer the data from MariaDB to the internal DB?

Thank you
Alex

[AleXSR700 (Alex)]

Anyone any idea?

[AleXSR700 (Alex)]

Seems the solution is here:

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…