His suggestion was plenty constructive. If you don’t have a working backup that means you don’t have a good enough backup solution. There were a couple long threads here a while back about how to verify db and what a good backup solution looks like.
Verify your db looks like a db then verify it. # file weewx.sdb weewx.sdb: SQLite 3.x database, last written using SQLite version 3026000 # echo "pragma integrity_check" | sqlite3 weewx.sdb ok If it fails you might need to dump and restore the archive table year by year until you determine where something wrong is located. Why did it happen ? Usually bad power to the pi or a failing SD card… -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/73ebbca0-1d95-4131-bc53-f79e70a92e3fn%40googlegroups.com.
