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 > > Our first choice would be to repair the above tables. But if this is too hard, our >next best option would be to just create a new database and restore the data from one >of our backups. So then I tried to create a new database. Even that does not work. >I enter "drop database deptpros" and the system just hangs. I then tried "create >database prod" and the system just hangs again.
Filesystem corruption or bad memory? Is your filesystem full? (just throwing some ideas around) --------------------------------------------------------------------- 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
