After having had a power failure, MySQL stalls when rebooting the server. The server running Ubuntu 7.04 server was stable before the power failure. In the boot sequence, it tries to start MySQL. It prints the message "Checking for corrupt, not cleanly closed and upgrade needing tables" and then stalls. Any ideas where to start?

I would start by disabling the auto-load of mysql & see if that's the thing that's actually causing the problem. It could be the thing right after that step, or something related to the disk itself. Regardless, just get the machine to boot, then debugging will become easier.

If you don't know how, there are a variety of ways. The easiest of which may be to boot off a CD, mount the drive, then remove the Sxxmysqld (or whatever it's called) from rc2.d (or whatever your default runlevel is), then boot off the hard drive.

It was a hardware failure. I resolved the hardware failure and now MySQL is fine and the machine boots normally.

I am having a similar problem, there is a script in /etc/init.d that wants to run on boot up, but stalls and I cannot do anything. How do I;

"The easiest of which may be to boot off a CD, mount the drive, then remove the Sxxmysqld (or whatever it's called) from rc2.d (or whatever your default runlevel is), then boot off the hard drive."
What cd do I want to use and how do I mount the drive? I think I can figure out the removing part, but I have tried morphix and ubuntu to boot from, I am not able to mount the scsi drive I have. If you have a more step by step method, I would really appreciate it.
I am running linux 2.22 and this all happened after a power outage.

Thanx Lisa