Powered by Invision Power Board

  Reply to this topicStart new topicStart Poll

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

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

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.


Fabrizio Ferrari - 'Violinist, contemporary and computer music composer'
E-MAIL: fabrizio@virtualsheetmusic.com
PMUsers Website
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.

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
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

Topic Options Reply to this topicStart new topicStart Poll