mysqldump: Error: Binlogging on server not active

4.74K 次檢視
备份数据库时报错，
mysqldump: Error: Binlogging on server not active
网上方法：
/etc/my.cnf 文件结尾添加
log-bin=mysql-bin
重启mysqld，不起作用 :(

原来不能放到最后，放到[mysqld]模块的最后 :) 

[mysqld]
datadir=/www/mysql
socket=/www/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-bin=/www/mysql/mysql-bin.log

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


117

评论

  1. 厉害

    1. @匿名 收复失地

    1. @匿名 收复失地

  2. I do not know what you are saying

  3. Cool gamepaly wallpaper

  4. z1IK9u <a href="http://ojfaayiwtiyo.com/">ojfaayiwtiyo</a>, [url=http://ptomybuiqqfl.com/]ptomybuiqqfl[/url], [link=http://ncqinrykxhff.com/]ncqinrykxhff[/link], http://cmoffjgdihei.com/

发表评论

电子邮件地址不会被公开。 必填项已用*标注

点击更换