mysqldump Error Binlogging on server not active

While using the mysqldump command in one of the MySQL server I got the error mysqldump: Error: Binlogging on server not active . Below given is the quick solution for it.

Details of MySQL Server:
MySQL Server: mysql-server-5.5.34
Error: Binlogging on server not active

Note: The path of my.cnf file

In CentOS and Red Hat
/etc/my.cnf

In Debian and Ubuntu

/etc/mysql/my.cnf

Note: Always take the backup of my.cnf file before editing

Solution: In my.cnf file add the below given parameter in [mysqld] section

log-bin=mysql-bin

Now restart the MySQL Server

In CentOS and Red Hat

/etc/init.d/mysqld restart

In Ubuntu and Debian

/etc/init.d/mysql restart

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.