Go语言视频零基础入门到精通

vcoole

今天想来把监控系统上的MYSQL log-bin参数打开,就修改了/etc/my.cnf添加了一行参数:

log-bin

重启就发现MYSQL启动不了啦!将/etc/my.cnf中添加的那一行删除再启动也不行!

后将/usr/local/mysql/var/mysql-bin.index文件删除后,解决问题!

报错信息:

080715 16:26:26  mysqld started
080715 16:26:26  InnoDB: Started; log sequence number 0 440358
^G/usr/local/mysql/libexec/mysqld: File './mysql-bin.000003' not found (Errcode: 2)
080715 16:26:26 [ERROR] Failed to open log (file './mysql-bin.000003', errno 2)
080715 16:26:26 [ERROR] Could not open log file
080715 16:26:26 [ERROR] Can't init tc log
080715 16:26:26 [ERROR] Aborting

080715 16:26:26  InnoDB: Starting shutdown...
080715 16:26:28  InnoDB: Shutdown completed; log sequence number 0 440358
080715 16:26:28 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

080715 16:26:28  mysqld ended

不知道什么原因!

晕死!  

jkmyf

不错的。谢谢喽








淄博旮旯