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]
