Difference between revisions of "Repairing a Corrupt Index File"

From support-works
Jump to navigation Jump to search
(Created page with "How to repair a Corrupt Index File This document details how to resolve an issue with a Corrupt Index on a MyISAM file. The error will be reported as follows in the log file ...")
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
How to repair a Corrupt Index File
+
{{Template:Basic Cover
 +
|title=How to Repair a Corrupt Index File in ESP 7.x
 +
|type=FAQ
 +
|htl=Y
 +
}}
 +
 
 +
{{Template:Basic Status
 +
|status=Published
 +
|version=1.0
 +
|authors=Hornbill Support
 +
|applicableto=Supportworks ESP 7.x
 +
}}
 +
 
 +
 
 +
== How to Repair a Corrupt Index File ==
  
 
This document details how to resolve an issue with a Corrupt Index on a MyISAM file. The error will be reported as follows in the log file
 
This document details how to resolve an issue with a Corrupt Index on a MyISAM file. The error will be reported as follows in the log file
Line 5: Line 19:
 
Can't open file: 'TABLENAME.MYD'. (errno: 145)
 
Can't open file: 'TABLENAME.MYD'. (errno: 145)
  
In order to resolve this please follow the instructions below
+
In order to resolve this please follow the instructions below:
 
   
 
   
 
  1...Run the SupportWorks Server Configuration Program. (Start-> Programs->SupportWorks->SupportWorks Configuration Program.)
 
  1...Run the SupportWorks Server Configuration Program. (Start-> Programs->SupportWorks->SupportWorks Configuration Program.)
Line 19: Line 33:
 
  Repair Table TABLENAME;
 
  Repair Table TABLENAME;
 
   
 
   
  8...Take a copy of the Results Returned. The table should now have been repaired. Please forward a copy of the table and results displayed to [email protected] Once received, we will endeavor to identify the root cause of the failure.
+
  8...Take a copy of the Results Returned. The table should now have been repaired.
 
   
 
   
 
  9...On the Server TAB start all remaining services.
 
  9...On the Server TAB start all remaining services.
  
  
Once done the Table will be repaired, should you require any further information and/or assistance please feel free to contact Hornbill Support on [email protected].com or call 0208 5828228.
+
Once done the Table will be repaired, should you require any further information and/or assistance please feel free to contact Hornbill Support using the webform https://support-works.com/support/

Latest revision as of 09:48, 31 August 2018



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


How to Repair a Corrupt Index File

This document details how to resolve an issue with a Corrupt Index on a MyISAM file. The error will be reported as follows in the log file

Can't open file: 'TABLENAME.MYD'. (errno: 145)

In order to resolve this please follow the instructions below:

1...Run the SupportWorks Server Configuration Program. (Start-> Programs->SupportWorks->SupportWorks Configuration Program.)
2...On the Server TAB STOP all Services
3...From the MS Windows Control Panel – STOP the the SwSQLServer Service.
4...Make a copy of the Corrupt Database files.
5...Re Start the SwSQLServer
6...Run the Support-Works Interactive SQL Program (Start->Programs->Hornbill Core Services ->Interactive SQL.)
7...Enter the following replacing DATABASE and TABLENAME with the appropriate values. 
 
Use DATABASE;   
Repair Table TABLENAME;

8...Take a copy of the Results Returned. The table should now have been repaired.

9...On the Server TAB start all remaining services.


Once done the Table will be repaired, should you require any further information and/or assistance please feel free to contact Hornbill Support using the webform https://support-works.com/support/