This is the message I got when I was trying to stop a MySQL server on my machine:
MySQL manager or server PID file could not be found
The command I executed:
service mysql stop
or
/etc/init.d/mysqld stop
I also attempted to start the MySQL server, but I got the following error
Starting MySQL.Manager of pid-file quit without updating file
I cannot access MySQL database.
A few points to address:
ps -ef |grep mysql
does not display any processes/var/run/mysqld/
is empty (no mysql.pid
file)/tmp/mysql.sock
does not existI read the file /var/log/mysqld.log
and it seemed that mysql was trying to do some crash recovery. There could be a shutdown yesterday but it was out of my control. I just want to get the database back. Can any expert help me? I have the sudo account of this machine but I would not reboot this machine unless it is the last option because it is a server used by other people.
I was getting the same error and after searching the first 4 pages of google and trying everything suggested (repairing tables, moving my.cnf, clearing locks, rebooting etc) nothing worked. It turned out that it was because I had manually cleared some old binary logs (binary.00001, binary.00002 etc) but i hadn't updated the binary.index file to match. I deleted the appropriate lines from binary.index and it just worked.