We are now trying to keep our site live, monitoring the online traffic 24X7 and supporting users who have any queries. Suddenly our live chat was down since this morning.
The error that kept coming up was "[SELECT username FROM livehelp_users WHERE sessionid='4d821a82f66f87decb92b77394b20ed6'] ( 1016 : Can't open file: 'livehelp_users.MYI'. (errno: 145) )"
Then when I search in google for a solution I found this help in the 'http://webmaster-forums.code-head.com/showthread.php?t=29'
It said that the problem could be one of the following reasons:
1 - Server crash; 2 - Hardware failure; 3 - A MySQL write process was interrupted;
and our livechat_users table got corrupted.

In our case I am sure it should be a MySQL write process being interrupted. Hence to fix the table I have used the query that was given in the forum,

Initally without reading the complete forum, I used PHPMyAdmin, a little hurry. Then I got read the complete forum and have a written a simple code
-> Created a connection to our database
-> used the two lines that was suggested in the forum.
And now the query is running. Our bad luck, suddenly our internet is prettly slow. We are just waiting for this script to get over so that we can start supporting you guys with full swing.
:) CIAO

Labels: Fixing live chat