Emergency!!!! MySQL just stopped working!!

[buzzt]

My MySQL service just stopped working and I can't get it to start again (on Win 2K Server). I rebooted twice, and still nothing! The error is below.

Could not start the MySQL service on local computer
error 1067: the process terminated unexpectedly.

 

[vanekl]

Check your MySQL error log.
The default location of this log is
c:/mysql/data/<hostname>.err
What does it say is the problem?
Did you run out of disk space?

 

[buzzt]

No, it has nothing of any consequence in it. The file is called mysql.err, and is in the root of the data folder. I have plenty of disk space left. Here's all there is...

MySql: ready for connections
040129 9:07:56 MySql: Normal shutdown

040129 9:07:58 MySql: Forcing close of thread 95538 user: 'USERNAME'

040129 9:07:58 MySql: Shutdown Complete

 

[vanekl]

You might want to try reinstalling MySQL.
A reinstall will not affect your database data.

Did anybody recently modify your my.ini or my.cnf file?
What happens when you double-click on winmysqladmin.exe?

You may want to try renaming your my.ini/my.cnf file to
something different to force MySQL to start with a clean
set of variables (if one of those variables is incorrectly set MySQL
will fail to start, but it should have said something in the err log).

 

[buzzt]

My my.ini is fine. Clicking on winmysqladmin.exe opens up the admin tool, but it obviously can't see the databases or tables therein. I just get some server and myini info.

 

[vanekl]

If the winmysqladmin stoplight (at the bottom-right
corner of your screen) is green then your server is
up and running. If so, run the mysql client program and try
to connect to the DB.

 

[buzzt]

Can I install MySQL right over top of itself without hurting anything?

 

[buzzt]

It's red. No go. Can I install MySQL right over top of itself without hurting anything?

 

[vanekl]

Yeah, you can install over a pre-existing installation
as long as MySQL is not running.

I would recommend, however, that you rename the bin directory
to something like 'bin_old' so the MySQL installation program
creates a completely new bin directory.

 

[buzzt]

Thanks. I'll try that. I assume that it has to be the same version?

 

[vanekl]

I've been upgrading from version 4.0.12 through 4.0.17
without any problems. I always overwrite the existing
version (except I rename the bin directory).
I think there would be problems,
however, if I upgraded to the alpha version 4.1.1, so
I haven't done that.

 

[buzzt]

Thanks for your help! I'll work on that.

 

[buzzt]

Installing over top didn't work. This is not good...

 

[buzzt]

After completely uninstalling, and also deleting the myini file, it now works.

Thanks again for all the help.

 

[ingresman]

A couple of questions

Was the server working before you tried to start it ?? i.e. have you upgraded anything or changed anything ?

Have you got a second machine ?. try setting up mysql on that and copying over your data files. at the bery least you should be able to salvage data and perhaps get you user service running.

Have you looked in the windows event log ?

regards

 

[buzzt]

I had just been logged into the server 10 minutes prior. I ran a flush-hosts, and everything seemed good. then, when I tried to log back in again, the service was stopped and I could not bring it back online.

I was able to salvage all my data, including all the grants, but I had to uninstall, and reinstall to get it back up. Good thing MySQL installs so quickly.