iron cloud
Hey,
is there a way to restore the energy dashboard data from an backup ?
Sadly my raspberry pi had a defect ssd which effects the backup. I can load it but after some time the pi does restart because of the defect files.
But the backup contains my solar data of the whole summer.
Is there a way to open the backup manually and export the information to the current HA installation via SQL queries?
It would be nice if I could restore the data to compare them in the next summer.
T
half geyser
I believe there is a custom component that allows you to import statistics from a csv file
if you can get your data exported from the old sqlite db you could maybe do that
there's nothing built in that will do this
you could probably do it with raw sql but it would be complicated
iron cloud
Is there a way to enter the sql data of an backup or does I need one HA installation where I import it ?
And how can I export it to csv ?
half geyser
I can't walk you through every step, if you have a copy of the database you'll probably need to learn how to export that data on your own, nothing built into home assistant supports this
worthy geyser
if you can get your data exported from the old sqlite db you could maybe do that
Could to share the name of this custom component. I can't find it in HACS