服务器重启mysql启动不了了,报错如下
Starting MySQL.The server quit without updating PID file (/var/lib/mysql/tserver.pid).[FAILED]
检查发现mysql的目录下有如下文件:
[root@server mysql]# ls
ibdata1 ib_logfile0 ib_logfile1 mysql RPM_UPGRADE_HISTORY RPM_UPGRADE_MARKER-LAST test server.err
删除了如下三个文件:
[root@server mysql]# rm ibdata1 ib_logfile0 ib_logfile1
rm: remove regular file `ibdata1'? yes
rm: remove regular file `ib_logfile0'? yes
rm: remove regular file `ib_logfile1'? yes
重新启动mysql server就可以了:
[root@server mysql]# /etc/init.d/mysql start
Starting MySQL.[ OK ]
[root@server mysql]# ps -ef|grep mysql
root 15166 1 0 06:12 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/tserver.pid
mysql 15257 15166 9 06:12 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/tserver.err --pid-file=/var/lib/mysql/tserver.pid
root 15284 14224 0 06:12 pts/0 00:00:00 grep mysql