重启之后mysql起不来,报错Starting MySQL. ERROR! Manager of pid-file quit without updating
军哥求助重启之后mysql起不来,报错Starting MySQL. ERROR! Manager of pid-file quit without updating file
MYSQL日志:
140411 16:02:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
140411 16:02:49 You need to use --log-bin to make --binlog-format work.
140411 16:02:49 Aborting 140411 16:02:49 /usr/local/mysql/libexec/mysqld: Shutdown complete
140411 16:02:49 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY1312261546182920f4Z.pid ended
140411 17:27:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
140411 17:27:30 You need to use --log-bin to make --binlog-format work.
140411 17:27:30 Aborting 140411 17:27:30 /usr/local/mysql/libexec/mysqld: Shutdown complete
140411 17:27:30 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY1312261546182920f4Z.pid ended
140411 18:11:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
140411 18:11:06 You need to use --log-bin to make --binlog-format work.
140411 18:11:06 Aborting 140411 18:11:06 /usr/local/mysql/libexec/mysqld: Shutdown complete
140411 18:11:06 mysqld_safe mysqld from pid file /usr/local/mysql/var/AY1312261546182920f4Z.pid ended 已解决,修改/ect/my.cnf 把binlog_format=mixed注释掉,mysql启动成功
页:
[1]