I had power down in my house and HA history is not longer visible. All history data as well as costs are gone. Database is corrupted and I have this file: home-assistant_v2.db.corrupt.2023-01-17T19_12_01.938720+00_00 which shows exact time and date when power was down. Can I somehow restore datab…

Yessssss… I did it. I managed to fix corrupted DB. How? First I transferred corrupted DB to my Windows PC. Then I needed to install Sqlite3 application and run it from Windows 10 CMD. In Sqlite3 command prompt I tried to use commands: .open home-assistant_v2.db .recover .save home-assistant_v2.…

Power down and database corrupt

Configuration

tom_l January 18, 2023, 3:01am 2

Search the forum for “repair database” it will return results like this: