Energy dashboard, long term history recording

[boheme61]

@RV1978

Ok, so there isn’t any change to export or migrate sqlite3 database to mariaDB?

i saw this the other day, have not tried as i deleted marieDB integration before i started using it, eventually i would like an “external” on “additional” samba-share if possible

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

I think I have just managed to migrate my SQLite DB to a Mariadb on another server (with over 1million rows in the states table and 2.7million in the events table!)… it appears to still have the entire available history in home assistant and is updating without errors in the logs. I had to do some additional steps on the database side to the original poster’s instructions, mainly to include the statistics tables and their foreign key constraints… Details below: Prepare the sqlite3 data (as per…

ohh looks like the same as above