maidi·· 发表于 2011-5-30 12:20:01

sos！mysql启动不了了

# /etc/rc.d/init.d/mysql start
Starting MySQL. ERROR! Manager of pid-file quit without updating file.


这是日志：
110530 12:07:53 /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 The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
110530 12:09:53 /usr/local/mysql/libexec/mysqld: unknown variable '/*binlog_format=mixed*/'
110530 12:09:53 Aborting

110530 12:09:53 /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 The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
110530 12:10:10 /usr/local/mysql/libexec/mysqld: unknown variable '/*binlog_format=mixed*/'
110530 12:10:10 Aborting

110530 12:10:10 /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:40

修改/etc/my.cnf 将
--skip-locking 替换为 --skip-external-locking

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

按https://www.vpser.net/manage/delete-mysql-mysql-bin-0000-logs.html 修改。
页: [1]
查看完整版本: sos！mysql启动不了了