• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
sharadchhetri

sharadchhetri

Tutorials On Linux, Unix & Open Source

  • Home
  • Linux Commands
  • Resources
    • Learn Linux
  • My WordPress plugins

mysqldump Error Binlogging on server not active

November 21, 2013 by Sharad Chhetri Leave a Comment

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

Share this:

  • Twitter
  • Facebook
  • More
  • Print
  • Email
  • LinkedIn
  • Reddit
  • Tumblr
  • Pinterest
  • Pocket
  • Telegram
  • WhatsApp
  • Mastodon

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

Filed Under: mysql Tagged With: mysql, mysqldump

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Our Social Media Presence

  • Facebook
  • GitHub
  • Twitter

Linux Command

What is Linux Internal And External Command

Linux Basic Commands With Examples For Every Beginner

tr command to convert lines to space , tab and vertical tab

smbpasswd command not found on CentOS 7 and RHEL 7

Solution : semanage command not found

Unix / Linux : How to print duplicate lines from file

More Posts from this Category

You Might Like These Articles!

simplecodesyntax wordpress plugin

SimpleCodeSyntax : My Another WordPress Plugin

Install Nginx

How To Install Nginx On Ubuntu 22.04 LTS

Install Latest Git package in Ubuntu Operating System

How To Always Install Latest Git Package In Ubuntu Operating System

Bash script for installing VirtualBox on Ubuntu 22.04 LTS Desktop

Install VirtualBox On Ubuntu 22.04 LTS Desktop (Bash Script)

libfuse

dlopen(): error loading libfuse.so.2 – Got Error On Ubuntu

Failed to open/create the internal network

VirtualBox Error: Failed to open/create the internal network

Always Useful Tips And Tricks

How to change login banner message in GUI mode in CentOS 6 or above version.

Error installing rails

error command ‘gcc’ failed with exit status 1 in Ubuntu

How to backup and restore iptables on Linux systems

Password prompt in single user mode is not secure : CentOS/Red Hat

postgres database backup script using database user password inside

error could not configure a c compiler Linux

Explore 90+ Article On "Linux Tips And Tricks"

Copyright © 2023 ยท
The material in this site cannot be republished either online or offline, without our permission.
Proudly Blogging From Bharat.

  • Contact
  • About Me
  • My WordPress plugins
  • Privacy Policy