When you stop MySQL, the kill command completes immediately, while MySQL is still doing shutdown tasks to make sure the database is in a consistent state. As MySQL is still running when you try to start it, it will fail to do so. There's 2 ways to fix this: - use mysqladmin shutdown, needs a user in the database with process privileges, this is the way used by debian - implement a loop that waits for MySQL to shutdown after executing the kill command. This is what the upstream MySQL start/stop script does. On Tue, 2010-03-23 at 22:46 -0400, Carlos Mennens wrote:
4. I then run the command to restart the daemon for MySQL and it fails...
Code:
[root@ghost /]# /etc/rc.d/mysqld restart :: Stopping MySQL Server
[DONE] :: Starting MySQL Server
[FAIL]
I can use the 'start' and 'stop' commands for /etc/rc.d/mysqld but 'restart' for some reason fails and this concerns me. Can anyone help me understand what is wrong?