backup strategy works (for once)
the journal of Michael Werneburg
twenty-seven years and one million words
Kokubunji, 2021.06.29
Today I discovered that something had gone wrong with the software I wrote to manage my book reviews. Instead of inserting a new database record with each new review, I was overwriting record number 7, from 1999. I never figured out how this was happening, but I managed to "fix" it with a value check and then I had to consider the damage. I was able to work out that I'd destroyed the original and overwritten four reviews in a row before I noticed. Incredibly, I was able to restore all but one of these with daily backups that I'd been doing (manually). It's like I work in IT or something.