Not a bad suggestion... but when I try it, I get the following output:
Checking MyISAM file: theTable
Data records: 22906970 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed and last repair failed
- check file-size
myisamchk: error: Size of indexfile is: 2049552384 Should be: 19229444096- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Can't read indexpage from filepos: -1
- check records and index references
myisamchk: error: Record at: 0 Can't find key for index: 1
MyISAM-table 'theTable' is corrupted
Fix it using switch "-r" or "-o"
Renato Golin wrote:
On Wednesday 06 April 2005 20:05, jon wrote:
Normal recovery seems to grab 490 rows... but, originally there were some 22 million rows in there.
Seems your data file was corruped too not only the indexes. and probably broke when updating the 491st registry... try use myisamchk -e
-e, --extend-check Try to recover every possible row from the data file Normally this will also find a lot of garbage rows; Don't use this option if you are not totally desperate.
it could take a very long time to run also... be warned! ;)
--rengolin
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
