themekill 发表于 2011-11-13 21:28:09

LNMP平台mysql启动故障

为了让mysql停止生产4G超级大垃圾，我使用 #log-bin=mysql-bin 注释掉这一项，可惜将LNMP平台restart时mysql启不动了，谁知道怎么解决？

licess 发表于 2011-11-14 10:39:16

发/usr/local/mysql/var/主机名.err 的错误信息

themekill 发表于 2011-11-15 18:26:37

/usr/local/mysql/var/主机名.err 的错误信息，如下
-------------------------------------------------------------------------------------------------------------------------------------------
111113 21:20:15 /usr/local/mysql/libexec/mysqld: Shutdown complete

111113 21:20:15 mysqld_safe mysqld from pid file /usr/local/mysql/var/227230.vps-new.pid ended
111113 21:21:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
111113 21:21:01 Event Scheduler: Loaded 0 events
111113 21:21:01 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
111115 18:18:01 /usr/local/mysql/libexec/mysqld: Normal shutdown

111115 18:18:01 Event Scheduler: Purging the queue. 0 events
111115 18:18:01 /usr/local/mysql/libexec/mysqld: Shutdown complete

111115 18:18:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/227230.vps-new.pid ended
111115 18:18:02 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
111115 18:18:03 You need to use --log-bin to make --binlog-format work.
111115 18:18:03 Aborting

111115 18:18:03 /usr/local/mysql/libexec/mysqld: Shutdown complete

111115 18:18:03 mysqld_safe mysqld from pid file /usr/local/mysql/var/227230.vps-new.pid ended

licess 发表于 2011-11-15 19:50:53

已经有mysql在运行，而且像是修改过/etc/my.cnf里的了
用log-bin替换 binlog-format

themekill 发表于 2011-11-15 22:45:59

OK，原来错误提示里面有解决办法，汗:L我没注意

themekill 发表于 2011-11-17 10:15:05

:victory: :victory: :victory: :victory: :victory:

回来给军哥说声：谢谢军哥，辛苦了！:lol

smartweb 发表于 2011-11-17 14:59:23

:lol :lol :lol :lol :lol :lol :lol
页: [1]
查看完整版本: LNMP平台mysql启动故障