Hello list, There's an corruption in my mysql table. I tried to use myisamchk -o to recovery, but still exists when I use myisamchk -s.
What is the possible reason of the problem? linux95:/var/lib/mysql# myisamchk -s stocks/TimelyDeals.MYI myisamchk: ISAM file stocks/TimelyDeals.MYI myisamchk: error: Size of datafile is: 5947722 Should be: 6016194 myisamchk: error: Keyblock size at page 284672 is not correct. Block length: 1022 key length: 2 MyISAM-table 'stocks/TimelyDeals.MYI' is corrupted Fix it using switch "-r" or "-o" linux95:/var/lib/mysql# -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpahud.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
