Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have several months working to "MySQL-5-1-47" on windows 2003. When I restarted, the service "MySQL" stay in this state "starting".

The only way to raise the service was running the program directly:

C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld

This is the MySQL error log

100906 16:07:29 [Note] Event Scheduler: Purging the queue. 0 events
100906 16:07:32  InnoDB: Starting shutdown...
100906 16:07:37 [Note] Plugin 'FEDERATED' is disabled.
100906 16:07:38  InnoDB: Shutdown completed; log sequence number 0 44233
100906 16:07:38 [Note] mysqld: Shutdown complete

100906 16:07:39  InnoDB: Started; log sequence number 0 44233
100906 16:17:21 [Note] Plugin 'FEDERATED' is disabled.
100906 16:17:22  InnoDB: Started; log sequence number 0 44233
100906 16:22:01 [Note] Plugin 'FEDERATED' is disabled.
100906 16:22:02  InnoDB: Started; log sequence number 0 44233
100906 16:22:02 [Note] Event Scheduler: Loaded 0 events
100906 16:22:02 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld.exe: ready for connections.
Version: '5.1.47-community'  socket: ''  port: 3306  MySQL Community Server (GPL)

The last lines are after loading the program from the shell

Thank.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Check out http://bugs.mysql.com/bug.php?id=49637. It describes the same symptoms that you are having. Ensure that your variables (such as tempdir) are defined correctly.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.