Update events set event_data = REPLACE(event_data, '`', '"') # 360 into recorder_runs, as well as 6 records into schema_changes for my # the above mysql statement imported about 55K records in both states and events, Mysql -u hass -p -h localhost hass < haimport.sql dump > hadump.sqlĬopied sqlite3-to-mysql to same directory as hadump.sqlīash sqlite3-to-mysql hadump.sql > haimport.sql Stop the hass server process on your server. I did the following 2 steps using phpmyadmin Sudo apt install mariadb-server mariadb-client So I am guessing that this will be the ‘final answer’ for hassos 2021.12… # The first few steps here are typical install and configuration of mariadb. What is the state class for the entities in your energy monitor? Sensor Entity | Home Assistant Developer Docs - I’m having an issue with mine (even prior to migration to MariaDb) because they’re declared as total_increasing yet they’re actually a daily amount. This could be a reason for the stats data going awry - for example if the energy integration is keeping a note of the last run or something like that. ![]() Was home assistant off while you exported the data/performed the migration? If not, there could be some statistics_runs that are missing in the MariaDb (statistics are run every hour according to the docs Home Assistant Statistics | Home Assistant). Some things to consider (I’m not claiming to know how this all works, but it would be interesting to see): We must be missing something with the way that the statistics work - I don’t really see any reason why a complete data migration between two different database engines should make any difference unless there’s still some data missing. I will then credit those that assisted with the updated instructions. I see the beginnings of a complete post, but would appreciate a complete sequence similar to what I posted. If one of you can combine what worked when I migrated some years before with what is working now, I would update my original post with the current working steps. ![]() Lly with the instructions that currently work for hassos 2021.12.X.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |