cheanshun 发表于 2014-4-11 18:32:41

重启之后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

cheanshun 发表于 2014-4-11 18:55:51

已解决,修改/ect/my.cnf 把binlog_format=mixed注释掉,mysql启动成功
页: [1]
查看完整版本: 重启之后mysql起不来,报错Starting MySQL. ERROR! Manager of pid-file quit without updating