I screwed up and now have to pay for it. I used to have a working backup automation, but somehow I switched to new router at the beginning of the year and failed to update / reinstall the Samba-Backup mechanism due to time etc… I always pushed this out thinking: next weekend I will do it.
Now SD card failure has hit me (I know, SSD are more resilient). I was able to restore the system to a state in early May as I have a full snapshot from that time.
I was able to rescue my config / homeassistant folder from the old SD Card (I’m on Home Assistant OS and a Raspi4).
I restored the system now to the state of early May on a new SD card, but obviously I lost all my longterm and energy data in between.
My idea is now to use the system restore from May and import the latest sqlite database file (home-assistant_v2.db) from early July manually. It does not seem to work as soon as I import it and restart, I get no energy statics or database history at all (despite the file being around 350MB).
I tried to apply the sqlite3 recover option and upload it again, as described here: Power down and database corrupt - #4 by e-raser but it did not help.
What am I doing wrong and any ideas how to restore the data between May and July?