It is with a heavy (OK, to be honest, a frustrated) heart that I must tell you that I made a bit of a goof-up (understatement) today. I went into Fantastico (the automatic script/software installer that sometimes comes with cPanel). Under “Blogs”, I noticed it said that I have a blog installed under the directory “wordpress”. Now, I’m 100% confident that such a directory does not exist in my site, so I thought that I had probably manually removed the directory and forgotten to update Fantastico. So I clicked on “Uninstall”, got the “Are you sure you want to do this? This action is not reversible!” (yawn), and clicked “yes”. AND THEN I saw what I’d done! (I could break out into a “I’ve created a monster!” type of melodramatic monolgue right now, but nevermind).
I had accidentally deleted the mySQL database and the user for Thought Overflow!! :O I then remembered that I had, in fact, installed this blog from Fantastico, and later changed its directory when I started blogging in earnest (and that is why there are no posts for a couple of months earlier this year ) So now what? Well, damage control! I had a backup of the blog’s DB made on Nov 20th, which meant I had all posts and comments made before that day. Google had a cache of my blog from Nov 30 or so, which meant that I still had the content of 2 out of last 3 blog entries I’d posted. I even magaed to get the categories, and date of posting. But I was lost as to what to do about the last entry (I had only posted it yesterday, sadly, and there was no chance any search engine would have cached it). Luckily, I started chatting with Yunheng (primarily for help on how to utilize my backed up DB) when it struck me that Opera takes a cache of all RSS feeds! And hallelujah! There it was in Opera’s cache! Sadly, there was no hope for all comments and ratings that have been posted these last 10 days )
Well, the good thing is that at least the blog is still alive. And henceforth, I promise to take a backup of the blog every Sunday
PS: This is the second time I’ve posted this blog entry too . Shortly after posting it for the first time, Bondings (the owner of my free hosting account) said that he had a backup which might restore my comments. Unfortunately, the backup was taken in that unfortunate period between my messing up of the original DB and posting this entry for the first time. The result was that not only had I lost the comments, but I had also lost this entry… thankfully, Opera came to the rescue again… there was a cache of the text of this post in the RSS Feeds, and now here it is, being posted for the second time