Difference between revisions of "Size Comparison of SwSQL with MS SQL"

From support-works
Jump to navigation Jump to search
(Created page with "{{Template:Basic Cover |title=How to Repair a Corrupt Index File |type=FAQ |htl=Y }} {{Template:Basic Status |status=Published |version=1.0 |authors=Hornbill Support |applic...")
 
(Blanked the page)
Line 1: Line 1:
−
{{Template:Basic Cover
 
−
|title=How to Repair a Corrupt Index File
 
−
|type=FAQ
 
−
|htl=Y
 
−
}}
 
  
−
{{Template:Basic Status
 
−
|status=Published
 
−
|version=1.0
 
−
|authors=Hornbill Support
 
−
|applicableto=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:
 
−
 
−
#  Run the Supportworks Server Configuration utility. (Start > Programs  > Supportworks Server > Supportworks Server Configuration.)
 
−
# On the Server tab, stop all services.
 
−
# From the MS Windows Control Panel, stop the SwSQLServer service.
 
−
#  Make a copy of the corrupt .MYI file and its associated .MYD file.  (Found in C:\Program Files\Hornbill\Core Services\SwSqlServer\data\''database''.)
 
−
# Restart the SwSQLServer service.
 
−
# Run the Interactive SQL program. (Start > Programs > Hornbill Core Services > Interactive SQL.)
 
−
# Enter the following, replacing <code>''database''</code> and <code>''table-name''</code> with the appropriate values.
 
−
#: <code>use ''database''; </code>
 
−
#: <code>repair table ''table-name'';</code>
 
−
#  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.
 
−
# 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.
 

Revision as of 09:15, 10 April 2015

Retrieved from ‘https://wiki.support-works.com/index.php?title=Size_Comparison_of_SwSQL_with_MS_SQL&oldid=104’