I had a master with two slaves replicating. I added two more DBs in
my.cnf for replication and did the standard procedure like lock the table for read, back up and restored the DBs to slaves. Now I am trying to restart my master MySQL server and getting error:
MySQL manager or server PID file could not be found! [FAILED] Starting MySQL.Manager of pid-file quit without updating fi[FAILED]
The output from the error log is as follows:
100914 09:22:43 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 100914 9:22:43 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead. /usr/local/mysql/libexec/mysqld: File '/usr/local/mysql/var/mysql-bin.index' not found (Errcode: 13) 100914 9:22:43 [ERROR] Aborting 100914 9:22:43 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete 100914 09:22:43 mysqld_safe mysqld from pid file /usr/local/mysql/var/mysql1.sitelms.org.pid ended
I have the file
/usr/local/mysql/var/mysql-bin.index and it does exist but
/usr/local/mysql/var/mysql1.sitelms.org.pid file does not exist. Can someone help me? I don't know what happened here.