Sunday, February 6, 2011

How do I repair a MySQL database table?

The “Can’t open file: ‘database_table.MYI’ (errno: 144)” error may be fixed by running a repair on the specified database table:

Here are the steps to repair a table in your database:

  1. Login to your Control Panel.
  2. Click Hosting.
  3. Choose Databases.
  4. For the database you wish to fix, click the phpMyAdmin link.
  5. Click your database ID located on the left (eg. d#######).
  6. Click the SQL tab.
  7. Enter the following in the Run SQL query/queries box (where table_name is the name of the table being referenced in the error message):
1repair table table_name;
If this does not fix it, attempt using the following SQL statement:
1repair table table_name USE_FRM;              source