Chances are, you need to type myisamchk -o *.MYI as you only want to run myisamchk on the Index file, which is typically the .MYI file. you probably typed myisamchk -o * which is wrong.
Try it out. Garrett On Tuesday 23 October 2001 05:10 pm, you wrote: > Hi! > > On Oct 23, David Potter wrote: > > Dear list members, > > > > We are running Mysql 3.23 on Redhat Linux 7.1. > > > > We have an emergency. This is the first time we have ever had a > > problem. Our production database suddenly crashed. I have tried to > > repair the tables with myisamchk commands, -r, -o, etc and nothing > > works. > > > > Here is the output: > > > > myisamchk: error: 'journal.frm' doesn't have a correct index > > definition. You need to recreate it before you can do a repair > > myisamchk: error: 'journal.MYD' doesn't have a correct index > > definition. You need to recreate it before you can do a repair > > This looks like hardware bug or linux kernel bug (there're some in older > versions). MySQL, by itself, NEVER writes to .frm file (besides ALTER > TABLE and CREATE TABLE). So, as you have .frm file corrupted, it was, most > probably, not due to MySQL bug. I'd recommend you to upgrade to the > latest linux kernel - especially, if your server is working under high > load. > > Do you have update log for the time of crash ? > > Regards, > Sergei --------------------------------------------------------------------- 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
