Powered by Invision Power Board


  Reply to this topicStart new topicStart Poll

> How to restart MySQL through shell command?
fabrizio
Posted: Apr 25 2007, 10:06 AM
Quote Post





Group: Members
Posts: 156
Member No.: 19
Joined: 16-July 02



Hello,
today I was working with PHP and MySQL and after a MySQL query to the server, MySQL stalled by using 99% of server CPU. I tried to kill its process on shell with root access, but the kill command was ignored. I then tried to restart MySQL, but the following command:

mysqld restart


which wasn't accepted ("too many arguments"??). My only chance was to stop and restart the server from the Control Panel which worked.

So, my question is: the next time such an issue happens, what is the right command to reset and restart MySQL from the shell?

Any information is very welcome, thank you in advance.

Sincereyl,
Fabrizio


--------------------
-----------------------------------------
Fabrizio Ferrari - 'Violinist, contemporary and computer music composer'
E-MAIL: fabrizio@virtualsheetmusic.com
http://www.musicianspage.com
http://www.virtualsheetmusic.com
PMUsers Website
Top
andy
Posted: Apr 25 2007, 10:34 AM
Quote Post





Group: Advantagecom Staff
Posts: 4,340
Member No.: 9
Joined: 12-July 02



'service mysqld restart' should do it. If that doesn't work, there are a couple of other things to try.


--------------------
Sincerely,
Andrew Kinney
CTO, Advantagecom Networks

Please do not private message me. My regular management duties preclude responding to every customer that sends me a support issue. Instead, post on the forum or contact tech support.
PMUsers Website
Top
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

Topic Options Reply to this topicStart new topicStart Poll