Table __________ is marked as crashed and should be repaired.

By: Emiley J. Emailed: 1728 times Printed: 2337 times    

Latest comments
By: rohit kumar - how this program is work
By: Kirti - Hi..thx for the hadoop in
By: Spijker - I have altered the code a
By: ali mohammed - why we use the java in ne
By: ali mohammed - why we use the java in ne
By: mizhelle - when I exported the data
By: raul - no output as well, i'm ge
By: Rajesh - thanx very much...
By: Suindu De - Suppose we are executing

Recently a friend of mine called me at 12 midnight. His voice was shaky and had a sense of urgency. "My Site is down. Can you help me with it?". I told him, "Its midnight here, do you mind?". He didn't seem to like my sense of humour. He was in panic. I recalled that his site was entirely dynamically generated with PHP and MySQL. All the pages were dynamically generated from the database. So if the database is down, his site is down.

I immediately got up and woke my computer too. It was no surprise that the first thing I did was to access his website and all I could see was a simple blank page. I rang him up again to get his control panel password. I logged into his website's control panel. It took only a few minutes for me to figure out the problem. When I tried to access one of the tables in his database via phpmyadmin, i got this error. Table __________ is marked as crashed and should be repaired.

The solution was right on my face. 'SHOULD BE REPAIRED'. So I used the control panel to see his databases. I chose the one that had this problem and repaired it. Of course there was a 'Repair DB' option provided on the control panel under 'MySQL databases' option. It took only a 3 seconds for the repair to finish successfully.

BINGO. the website was up again. So if you are facing this issue all you have to do is to repair the database in question. Don't panic. In addition take these steps to avoid future panic.

1. Do a regular backup of your databases.
2. Index your tables based on the 'WHERE' clause of your queries.
3. Optimise your SQL queries properly.

 


MySQL Home | All MySQL Tutorials | Latest MySQL Tutorials

Sponsored Links

If this tutorial doesn't answer your question, or you have a specific question, just ask an expert here. Post your question to get a direct answer.



Bookmark and Share

Comments(2)


1. View Comment

I have a site fully based on php and mysql.The log table contains large amount of data.When power off or after rebooting the table got repaired.can you please send me the solution for this.Thanks in advance.

View Tutorial          By: titus at 2011-06-14 00:52:30
2. View Comment

Hi!
this morning when i tried to logon a private server to wow it said that my user/password was wrong so i got in to the site (http://www.zwowz.com/) and it said "MySQL reported: Table './authentication/account' is marked as crashed and should be repaired" im not that kind of guy who are good at computers and stuff like that but does that mean the thing you said in the text???


View Tutorial          By: Lukas at 2013-03-03 13:35:42

Your name (required):


Your email(required, will not be shown to the public):


Your sites URL (optional):


Your comments:



More Tutorials by Emiley J.
Error generating R.java from manifest
ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
IIS and Tomcat - how to configure to work together
PHP Warning: Unknown(): Unable to load dynamic library '/usr/local/php4/lib/php/extensions/no-debug ......
Adding your own Application icon for your J2ME application (jar file)
Creating Menus in Code using VB.net
Traversing all files in a directory using Ruby
Using Proxy to connect to URLs in Ruby
POST a form in Ruby
Reading URL content using Ruby (HTTP)
dRuby client/server mode sample program
Benchmark module in Ruby
encoding and decoding in Ruby using Base64 Module
Module Abbrev in Ruby
Standard Library Packages in Ruby

More Tutorials in MySQL
Windows cannot access the specified device, path or file. You may not have the appropriate permissions to access them.
ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Changing the Structure of an Existing Table in MySQL
Inserting Data into Tables in MySQL
Querying the Database in MySQL
Modifying data and using WHERE clause in MySQL
Deleting Data in MySQL
What is SQL Injection
MySQL Strengths and Weaknesses
Table __________ is marked as crashed and should be repaired.

More Latest News
Most Viewed Articles (in MySQL )
Changing the Structure of an Existing Table in MySQL
Table __________ is marked as crashed and should be repaired.
Querying the Database in MySQL
Deleting Data in MySQL
ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
What is SQL Injection
MySQL Strengths and Weaknesses
Inserting Data into Tables in MySQL
Modifying data and using WHERE clause in MySQL
Windows cannot access the specified device, path or file. You may not have the appropriate permissions to access them.
Most Emailed Articles (in MySQL)
MySQL Strengths and Weaknesses
Inserting Data into Tables in MySQL
Modifying data and using WHERE clause in MySQL
Deleting Data in MySQL
ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Windows cannot access the specified device, path or file. You may not have the appropriate permissions to access them.
Table __________ is marked as crashed and should be repaired.
What is SQL Injection
Changing the Structure of an Existing Table in MySQL
Querying the Database in MySQL