New User ? Sign Up  |  Sign In  |  Help
ask
answer
discover
     
Search for questions :
My Profile
Categories

Ronnie

Open Question Bookmark and Share

How to Repair Crashed Tables in MySQL Database ?

One of the tables in MySQL Database is crashed due to the sudden termination of the computer. I have tried a lot to get access to that crashed but I was not able to do so. Can anyone tell me how to get this crashed table repaired?

361 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

Sambhavi
You can try out the following manual operations to get your crashed database table repaired. First of all try this command: myisamchk –r –q tbl name. By using this command, the index file will be repaired without touching the data file.

If the above command fails, then try out the following command: myisamchk –safe-recover tbl name. By using this command, the crashed database table would be repaired as well as recovered.

Even by running these 2 commands, the damaged table is not repaired then I would recommend you to use MySQL Database Repair software. This software by its sophisticated algorithm will help you in repairing the crashed tables of MySQL Database.


Posted 361 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0