VPS侦探论坛

 找回密码
 注册
查看: 6877|回复: 6

LNMP平台mysql启动故障

[复制链接]
发表于 2011-11-13 21:28:09 | 显示全部楼层 |阅读模式

为了让mysql停止生产4G超级大垃圾,我使用 #log-bin=mysql-bin 注释掉这一项,可惜将LNMP平台restart时mysql启不动了,谁知道怎么解决?
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2011-11-14 10:39:16 | 显示全部楼层


发/usr/local/mysql/var/主机名.err 的错误信息
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2011-11-15 18:26:37 | 显示全部楼层

/usr/local/mysql/var/主机名.err 的错误信息,如下
-------------------------------------------------------------------------------------------------------------------------------------------
111113 21:20:15 [Note] /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 [Note] Event Scheduler: Loaded 0 events
111113 21:21:01 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
111115 18:18:01 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

111115 18:18:01 [Note] Event Scheduler: Purging the queue. 0 events
111115 18:18:01 [Note] /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 [ERROR] You need to use --log-bin to make --binlog-format work.
111115 18:18:03 [ERROR] Aborting

111115 18:18:03 [Note] /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
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2011-11-15 19:50:53 | 显示全部楼层



已经有mysql在运行,而且像是修改过/etc/my.cnf  里的了
用log-bin替换 binlog-format
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2011-11-15 22:45:59 | 显示全部楼层

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

军哥运维代购:http://shop63846532.taobao.com/

 楼主| 发表于 2011-11-17 10:15:05 | 显示全部楼层



回来给军哥说声:谢谢军哥,辛苦了!
发表于 2011-11-17 14:59:23 | 显示全部楼层

美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-9-21 17:30 , Processed in 0.026956 second(s), 17 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表