I have already changed the config to an external MariaDB which now contains data for a day.
You can convert the .db to .sql via Migrate sqlite database to MySQL.
Can I add this to the MariaDB without issues and data loss?
Yes there is a way to do this, but no always with risks.
i did write an tutorial, but please read everything posted in that topic, i don’t recommend it for everyone.
It was time consuming and lot of stress…
i did create this because i had an error with my costs entity so i needed to convert the old DB to Maria db… but now i would prefer just using the default DB.
MariaDB for me is only handy to be hosted on separate servers.
Also this was written in MARCH 2023, so many many HASS versions before the last one… so i really don’t know if it still works… u have to test it in test environment
So what you’re saying is, if you switch you will lose your old data.
Only if you want to spend a lot of time with testing and transferring to dump databases and checking if nothing has become corrupted you can transfer it.