Comments missing in Movable Type!!
When I logged into MT after a long time, I was surprised to find that all the previous comments were missing!! After some googling found that the problem was caused by a corrupt mt_comment table. I tried to do a repair by issuing the following command.
But this didn't help.
I then used MySQL Administrator (GUI tools) and selected repair on the table with the following settings.
This fixed the problem.
