mysqldump: Got error: 144: Table ‘xxxxxxxxxxxxxx’ is marked as crashed …

 

Here is how to fix a corrupted table (note the single ‘s and {} pairs are not part of the sql commands but are used for clarity and that the “;” are required):

  • Log into mysql as administrator
  • select the database containing the corrupted table, i.e., ‘use {database name};’
  • ‘show tables;’ your corrupted table should be listed
  • ‘repair table {bad_table_name};’
  • ‘unlock tables;’

 

Done

Leave A Reply

Your email address will not be published. Required fields are marked *

*

Bad Behavior has blocked 360 access attempts in the last 7 days.