mysqldump Error Binlogging on server not active

by

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

Related posts:

  1. mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed
  2. fatal error: error writing to /tmp/ccwAjc9Z.s: No space left on device
  3. error: The requested URL returned error: 403 Forbidden while accessing Github repo
  4. dlopen(): error loading libfuse.so.2 – Got Error On Ubuntu
  5. owncloud error : You are accessing the server from an untrusted domain
  6. Beginners 4 basic commands of database in mysql server
  7. How to check default storage engine in MySQL server
  8. Set delay replication to MySQL slave server
  9. How to install mysql server 5.6 on Ubuntu 14.04 LTS ( Trusty Tahr )
  10. How to install MySQL Server 5.6 on CentOS 7 / RHEL 7

Leave a Comment

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