Articles in this section

mysqldump: Got error: 145: Table 'Table_Name' is marked as crashed

Brad Alexander
  • Updated
Follow
  1. Product Version:
    2. ServosityPro: All
    OS: All platforms
  2. Problem Description:
    3. When performing a mysql database backup, the following error message is received in the backup report:
    Backup Logs
     No.  Type  Timestamp  Backup Logs
    1 Info YYYY/MM/DD hh:mm Start [ All platforms (Test), ServosityPro 5.x.x.x ]
    2 Info YYYY/MM/DD hh:mm Start running pre-commands
    3 ... ... ...
    *  Error  YYYY/MM/DD hh:mm mysqldump: Got error: 145: Table 'Table_Name' is marked as crashed and should
    be repaired when using LOCK TABLES
  3. Cause:
    4. The message suggests that the corresponding table may be corrupted.
  4. Resolution:
    5. To resolve the issue, please repair the corresponding table. You can try the following command:

         Example:
         >myisamchk -c -r *.MYI

    Notes:  Myisamchk is a utility used to retrieve information regarding your database tables. It also checks, repairs, or optimizes your database tables.
  5. Also See: http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html