VPS侦探论坛

标题: sos！mysql启动不了了 [打印本页]

作者: maidi·· 时间: 2011-5-30 12:20
标题: sos！mysql启动不了了
# /etc/rc.d/init.d/mysql start
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

这是日志：
110530 12:07:53 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110530 12:07:53 mysqld_safe mysqld from pid file /usr/local/mysql/var/li161-96.pid ended
110530 12:09:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110530 12:09:53 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
110530 12:09:53 [ERROR] /usr/local/mysql/libexec/mysqld: unknown variable '/*binlog_format=mixed*/'
110530 12:09:53 [ERROR] Aborting

110530 12:09:53 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110530 12:09:53 mysqld_safe mysqld from pid file /usr/local/mysql/var/li161-96.pid ended
110530 12:10:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110530 12:10:10 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
110530 12:10:10 [ERROR] /usr/local/mysql/libexec/mysqld: unknown variable '/*binlog_format=mixed*/'
110530 12:10:10 [ERROR] Aborting

110530 12:10:10 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110530 12:10:10 mysqld_safe mysqld from pid file /usr/local/mysql/var/li161-96.pid ended

请帮帮我吧

作者: licess 时间: 2011-5-30 13:08
修改/etc/my.cnf 将
--skip-locking 替换为 --skip-external-locking

你应该还修改过mysql的日志。/*binlog_format=mixed*/ 这么改出错了。

按https://www.vpser.net/manage/del ... -bin-0000-logs.html 修改。

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)