«

»

Jun 22 2008

How To Fix MySQL Tables That Have Crashed

The other day at work there one of the tables crashed on us in our development site and we were unable to access any of the data. I was going to just replace the data from our live site, but my co-worker Joe suggested that we figure out a solution in case it happens on live.

After looking up the documentation we realized that if you shut down the mysql server and go into the directory that the data is located, you can type in the following command, it will fix the table without touching the data.

“myisamchk -r -q name_of_table.MYI”

Hope this helps.

About the author

Timothy Haroutunian

Timothy Haroutunian is a ServiceNow Cloud Implementation Specialist at Acorio. ServiceNow is an IT Management solution that allows for a complete view of your IT and physical environment.

Permanent link to this article: http://www.armenianeagle.com/2008/06/22/how-to-fix-mysql-tables-that-have-crashed/

http://pagead2.googlesyndication.com/pagead/show_ads.js

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.