Manager of pid-file quit without updating fi

Error : Manager of pid-file quit without updating fi

Solution : 

When try to restart the mysql service on the server then above error is generated.

This problem is occurred due the “mysql ” database crashed and should be repaired but the mysql is already stopped on the server  so you need to use the following command to repair and optimize the database when mysql service is down on the server.

For Repair “mysql ” database

# find /var/lib/mysql/mysql  -name '*.MYI' -exec myisamchk -r {} \;

For Optimize the database

# find /var/lib/mysql -name '*.MYI' -exec myisamchk -o {} \;

Then

# ps -ef | grep mysql

# killall -KILL mysql

# /etc/init.d/mysql stop

# /etc/init.d/mysql start

Done

Both comments and pings are currently closed.

Comments are closed.