mysqldump: Error: Binlogging on server not active
This is a wiki page. Be bold and improve it!
If you have any questions about the content on this page, don't hesitate to open a new ticket and we'll do our best to assist you.
Error:
mysqldump: Error: Binlogging on server not activeEdit my.cnf (/etc/mysql/my.cnf), and in the [mysqld] section, add:
log-bin=mysql-bin
# Or set the full path to the binary log file:
# log_bin = /var/log/mysql/mysql-bin.logRestart the mysql service. mysqldump should now work.
Alternatively, disable binary logging in your script. Remove the following mysqldump options:
#--flush-logs
#--master-data=2