Hello list, This is the output of mysql myisamchk -s */*.MYI, which seems very badly corrupted. I know myisamchk -o or myisamchk -c will rescue this, but is any idea to know what made the corruptions?
myisamchk: ISAM file stocks/TimelyDeals.MYI myisamchk: error: Size of datafile is: 5645430 Should be: 5969700 myisamchk: error: Keyblock size at page 1562624 is not correct. Block length: 772 key length: 2 MyISAM-table 'stocks/TimelyDeals.MYI' is corrupted Fix it using switch "-r" or "-o" myisamchk: ISAM file stocks/TimelySecIndex.MYI myisamchk: error: Size of datafile is: 878400 Should be: 925920 myisamchk: error: Found key at page 704512 that points to record outside datafile MyISAM-table 'stocks/TimelySecIndex.MYI' is corrupted Fix it using switch "-r" or "-o" myisamchk: ISAM file stocks/news.MYI myisamchk: error: Size of datafile is: 516728 Should be: 531496 myisamchk: error: Found key at page 113664 that points to record outside datafile myisamchk: error: Record-count is not ok; is 667 Should be: 688 myisamchk: warning: Found 667 parts Should be: 688 parts MyISAM-table 'stocks/news.MYI' is corrupted Fix it using switch "-r" or "-o" myisamchk: MyISAM file tv2/sectors_names.MYI myisamchk: warning: 1 clients is using or hasn't closed the table properly MyISAM-table 'tv2/sectors_names.MYI' is usable but should be fixed --------------------- Original Message Ends -------------------- -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatezplay.gpg --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
