Cannot restart service MySQL

2006-03-31 Thread Sara Woglom
Please help, I can't start my server!!  
I was running a query, and it seemed to be hanging.  After waiting about 15
minutes, I finally did a 'CTRL+BREAK' to abort the process.  This happened
about 3 times, and finally I decided to restart the MySQL service to see if
that would help.  Well, when I did that, the service wouldn't stop.  Now
when I go into the Services manager in Windows, the MySQL service is listed
as 'Stopping,' and all the control buttons (stop, start, restart) are all
grayed out.  The problem is, the service is NOT stopping and I can't restart
it doing a 'mysqld --console' either.  What do I do?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Cannot restart service MySQL

2006-03-31 Thread Johan Lundqvist

In Windows, you have 3 alternatives:

1 - wait untill it stops the service (can take very long time).
2 - restart the server (your users might cry a bit).
3 - Try to kill the task using Task Manager (this might not work, 
depending on the service).


/Johan

Sara Woglom wrote:
Please help, I can't start my server!!  
I was running a query, and it seemed to be hanging.  After waiting about 15

minutes, I finally did a 'CTRL+BREAK' to abort the process.  This happened
about 3 times, and finally I decided to restart the MySQL service to see if
that would help.  Well, when I did that, the service wouldn't stop.  Now
when I go into the Services manager in Windows, the MySQL service is listed
as 'Stopping,' and all the control buttons (stop, start, restart) are all
grayed out.  The problem is, the service is NOT stopping and I can't restart
it doing a 'mysqld --console' either.  What do I do?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Cannot restart service MySQL

2006-03-31 Thread Sara Woglom
Sorry, I should have been more specific.  I tried 'mysqladmin -u root
shutdown -p' and that did not work.
The service is hung up in a pending state and I cannot control it.  It is
Net Error 2189: 'The service could not be controlled in its present state.'
There has to be some way I can fix this without bouncing the server, because
I really can't do that.



-Original Message-
From: Ariel Sánchez Mora [mailto:[EMAIL PROTECTED]
Sent: Friday, March 31, 2006 4:10 PM
To: Sara Woglom
Subject: RE: Cannot restart service MySQL


Have you tried

Command line: mysqladmin -u root shutdown -p

Without the . If it has a password, it will ask for it. If it doesn't,
remove the -p.

If that doesn't work, tell the mailing list what you did, any error messages
you may get, and they'll tell you what the problem is. I'm not a MySQL guru
so I would restart the machine (but I imagine you can't do that?) and try
starting it again, or make a new install. It may be your computer is
overloaded at the moment, or some program doesn't let your server exit. Good
luck!

ariel



-Mensaje original-
De: Sara Woglom [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 31 de marzo de 2006 15:05
Para: MySQL List
Asunto: Cannot restart service MySQL


Please help, I can't start my server!!
I was running a query, and it seemed to be hanging.  After waiting about 15
minutes, I finally did a 'CTRL+BREAK' to abort the process.  This happened
about 3 times, and finally I decided to restart the MySQL service to see if
that would help.  Well, when I did that, the service wouldn't stop.  Now
when I go into the Services manager in Windows, the MySQL service is listed
as 'Stopping,' and all the control buttons (stop, start, restart) are all
grayed out.  The problem is, the service is NOT stopping and I can't restart
it doing a 'mysqld --console' either.  What do I do?



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]