I don’t know how did that happen, but yesterday I noticed all of the comments were vanished from one of my wordpress blog : Calcutta Tube.
I Panicked, as I should, and then tried to search google to see if anybody else had the same trouble. I found few cases for older version of wordpress. Such as for wordpress 2.3, the solution for “disappeard comments” are given by Steve Ferson. I found that David Perkinson had the same problem but he mentioned that it was related to some plugin issue. He thought “google analytics” was the problem plugin for “disappearing comments”. Well I do not have “Google Analytics” installed in my blog, so what is the solution. I checked all plugins to make sure they are “up to date”. Updated few plugins that we not up to date. But still the problem remained. So, I did the most useful thing that I should have done in the first place.

I have Cpanel installed in my server. So, my trick is useful if you have Cpanel or you know how to repair your database!

Log on to your cpanel and you should see something like the image below. Click on the “MySQL Databases”. It will list all the databases you are using in your site.

Browse to the database that you are using for your wordpress. Then click on repair. There are three buttons next to each databases - Delete, Check and Repair. Do not click on “delete” even by mistake!

Hopefully it will solve your problem. It did for my blog!

Enjoy Blogging now!