If you visited Noscope last night between 23:20 and 23:50, you’d see anguish and pain. Well, actually you’d see the body of every entry ever written simply say
post_content, but the former more accurately represents what I saw.
In five seconds, everything I had written over the last 5 years was gone.
The story began with a simple wish on my part, to move some images and update the paths to these in WordPress. Hey, I figured. A quick MySQL search & replace will do the trick. While it could have worked, the result was quite terrifying. In five seconds, everything I had written over the last 5 years was gone. 572 entries of variable quality was reduced to binary rubble.
The story ends rather well, fortunately. Prior to performing said search & replace, I had backed up the lot. Twice. I had done so the week before, and the month before that. Even so, there could have been problems with the backups (MySQL exports), there could’ve been
UTF-8 problems, this and that. The fact that this log remains unfazed by yesterdays tumultuous events seems a miracle.
The moral of the story is, of course: backup. Make copies of your stuff. Keep it in various places. Email it to your Gmail. Automatize it. Most importantly: do it now, or in the words of Mao Zedong: Get to work!