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.cnfIn 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
