I'm trying to reconcile an energy bill, but usage data only goes back to 21st April. I've looked at the database with SQLite Web and see no data before 21st for anything at all. I've been collecting energy data for years. I also see an entry in the schema_changes table for the 21st? Coincidence? I think not. I suspect the DB has been corrupted. So... I'm looking at the command line shell for SQLite to try using the recovery procedure. But not sure how to get started. Can I just install the sqlite3 program from a HA terminal, or do I need to get into the SQLite container? Is this even the correct topic to be asking these questions?
Thanks in advance.
#Energy Dashboard data gone missing
acoustic stratus
wild ginkgo
No but you can simply reload a backup to the last time it worked