MySQL Starts But Fails to Restart
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...
> [root@ghost /]# /etc/rc.d/mysqld restart
> :: Stopping MySQL Server
> :: Starting MySQL Server
> 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?