How to Repair a Corrupt Index File

Status:	Published
Version:	1.0
Authors:	Hornbill Support
Applies to:	Supportworks ESP

How to Repair a Corrupt Index File

This document details how to resolve an issue with a corrupt index file (extension .MYI) in the MySQL database. The error is reported as follows in the log file:

Can't open file: 'TABLE-NAME.MYI'. (errno: 145)

In order to resolve this, please follow the instructions below:

1. Run the Supportworks Server Configuration utility. (Start > Programs > Supportworks Server > Supportworks Server Configuration.)
2. On the Server tab, stop all services.
3. From the MS Windows Control Panel, stop the SwSQLServer service.
4. Make a copy of the corrupt .MYI file and its associated .MYD file. (Found in C:\Program Files\Hornbill\Core Services\SwSqlServer\data\database.)
5. Restart the SwSQLServer service.
6. Run the Interactive SQL program. (Start > Programs > Hornbill Core Services > Interactive SQL.)
7. Enter the following, replacing database and table-name with the appropriate values.

   use database;

   repair table table-name;

8. Take a copy of the results returned. The table should now have been repaired. Please forward a zipped copy of all your log files (found in C: \Program Files\Hornbill\Supportworks Server\log\) to [email protected]. Once this has been received, we will try to identify the root cause of the failure.
9. On the Server tab of the Server Configuration utility, restart all remaining services.

Should you require any further information and/or assistance please feel free to contact Hornbill Support on [email protected] or call 0208 5828228.