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 -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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
