Patrick, Try this from your shell: You want to flush the tables (I'm assuming you want to keep the database up and running), do a recover, safe recover, and check to make sure you don't get the error messages when everything is finished.
$ mysqladmin flush-tables $ myisamchk -r -o /var/lib/mysql/*/*.MYI $ myisamchk --fast --silent /var/lib/mysql/*/*.MYI If that still doesn't work, then shutdown your database, just try: $ mysqladmin shutdown $ myisamchk -r -o /var/lib/mysql/*/*.MYI $ myisamchk --fast --silent /var/lib/mysql/*/*.MYI Then start the database again. This should work. If this does actually work, then you should consider doing a database dump then rebuilding your database from the dump. Thanks, ozette Patrick Hsieh wrote: >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# > -- _______________________________________ Email: [EMAIL PROTECTED] --------------------------------------------------------------------- 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
