Where Have All The Comments Gone?
Posted on 11 Dec 2006 under Humour, Site Designing
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 :P. 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 ![]()


(4 votes, average: 3.75 out of 5)
right, even after the post script, i still don’t understand 1 damn thing abt this post…lol :rasberry_ee:…wanna make something that makes sense to us lesser beings, g? :help_tb: :tongue2_tb:
ps. just because u have so many smileys, i’m trying to incorporate the most into my comment… :thumbup_tb:
Dearie, once I enable the Yahoo smileys and disable all the others, you won’t be able to see your smileys… all you’ll see is the code
noooo!! don’t disable any!!!
:cry_wp: :furious_tb: :cry_tb: :thumbdown_tb: :mad1_ee: :angry_ee:i’ll :beatup: u up
Hmm and the lesson for the day is back-up… *reminds self, what happens when hard-drive crashes into oblivion…* 8-}
My comments! My beautiful comments! Ruined! All ruined! :cry_tb:
Comments aren’t really important to me, the posts are :o.
Hey look, a missing image in my above comment :P.
Just one thing to say gurdit. What a dumbass
Wow! Not a single spelling mistake, Blaster.
However, a grammar mistake… you should capitalize the first letter in proper nouns - “Gurdit”, see?
@Yun, some of the smileys aren’t perfect yet… need a little more work… the internet was off for the last couple of days.
Sorry Gurdit anyhow still looks really nice
:flush_tb: