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. Thank you
