Repairing Crashed MySQL Database tables. “table ‘employee’ has crashed.”
Hi all,
Today i just want to start by sharing an experience that i had with MySQL Database. I was a project for a friend. The project was a CMS for a movie site and all of a sudden an error message started appearing, that the
table “employee” has crashed.
This made the admin page inaccessible. The true is if you have been working with MySQL for sometime you might have seen this error. I want to share with you i i fixed this error.Â
Before that i want to ask “Does anyone what causes MySQL table to crash” if you do please leave a comment as to how.
Okay the solution is rather simple. I asked myself why the creators didn’t make such a thing automatic.
Okay you just open phpmyadmin or any interface that you have to mysql access the database and then just type the command
repair [tablename];
Befor you go rushing just go to mysql’s website(www.mysql.org) and read the whole thing.
This post is for you so that you don’t panic when you see a message like that. You have to read the whole documentation……….
You can also try this, from command prompt :
cd /var/lib/mysql/
mysqlcheck -r
or if the storage engine is myisam them try this :
myisamchk -r /*.MYI
This will repair the whole data-base.
Ravi
October 20, 2008 at 6:53 pm
Can you help me with the yum .. I am trying to install vlc on centos:
yum -y install vlc
but its not getting install… says that nothin to install !
Ravi
October 20, 2008 at 7:03 pm