You may have noticed that the site was down for a couple of hours yesterday, and when it was back up, that most of the content was missing until this morning.
Well, my fault – I was doing some database maintenance, and inadvertently dropped the entire database. Normally, that wouldn’t be a bad thing.
Except when your backup script isn’t running. Gulp!
I’ve just moved the site from an older server, onto a newer one – and was cleaning up afterwards. Hence the need to do a little database maintenance. However, I’d not started using the database backup script on the new server yet.
Needless to say, I am now. I found enough data from old dumps, and RSS feeds, that I was able to piece it all back together.
And yes…I do feel like a dill! Moral of the story – completely wake up, and have at least one coffee before doing database maintenance.