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

scotttaylor

Open Question Bookmark and Share

How to resolve error codes 126, 127, 144 and 145 of MySQL database?

Last night I got some errors while mounting MySQL database. I am using MySQL database for a long time and never faced any problem with it. But I don’t know why when I tried to perform the mounting of MySQL database ‘Employee’ following error messages are received –

‘Got error 126 from table handler’
OR
‘Got error 127 from table handler’
OR
‘Got error 144 from table handler’
OR
‘Got error 145 from table handler’

Soon after the error the data stored in the database became inaccessible and the error message comes each time when I mount the employee database. Please help me to resolve this issue, any help or suggestions will be appreciated. Thanks in advance.

163 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)

sahilkumar 		Since errors has occurred during mounting of the MySQL database, so I am quite sure that the database you are trying to mount has corrupted after the damage in the table handler due to which the MySQL database has become inaccessible. In order to resolve this issue first try some inbuilt utilities like ‘Check command’ to check the severity of the corruption. Then run the ‘repair’ command to repair the MySQL database, if it fails to repair the database then use the valid backup available and restore the database. If the backup is not available or has damaged then you need to use any third party software to repair the MySQL database. MySQL Repair software will be ideal in these conditions as it effectively repairs the MySQL database and makes the data stored into it accessible.

Posted 163 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