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;’


Leave a Reply

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


This site uses Akismet to reduce spam. Learn how your comment data is processed.