Mysqldump Backup report binlogging on server not active resolution

Redhat 6.5 X64 Mysql 5.7 performs a backup:

[Email protected] 3306]# mysqldump-u root-p--master-data=2--single-transaction-r--triggers-a > All.sql
Enter Password:
Mysqldump:Error:Binlogging on server not active

Solution:

sudo vi/etc/my.cnf

Under the [Mysqld] tab, add:

Log-bin=mysql-binserver-id=1

After saving exit, restart the service:

Systemctl Restart Mysqld

Take care of it. Note If there are other errors, look carefully

/var/log/mysqld.log inside the error message to find the problem faster.

Refer to the following content.

1) First, why should I turn on Binlog log and slow query log?

Binlog log will be recorded in the database, so adding and deleting the operation, when accidentally delete, empty data, or database system error, this time you can use the Binlog log to restore the database, simply, is a record backup of things

Slow query log Slow_query_log, this thing is used to record query slow SQL statements, query the log to find which SQL statement is slow, then you can do database or SQL statement or program optimization, simply is an optimization helper

Ps:binlog log should be open all the time (because you do not know which day the database will be collapsed, or one day will mistakenly delete a thing), slow query log can not open, when the site is slow, need to optimize, you can open slow query to do an auxiliary

2) How to open Binlog log

Add a Binlog configuration under My.cnf [mysqld] (note that it must be added under [mysqld], if not in [Mysqld_safe] or other locations), configure as follows:

Log-bin=mysql-binserver-id=1

PS: The above mysql-bin is actually the Binlog log file prefix, like the above set is Mysql-bin (you can change to mysql_bin or binlog or anything else), it will be in the/var/lib/mysql/ Generate mysql-bin.000001,mysql-bin.000002,mysql-bin.000003 (default location) ... and other log files

3) Turn on slow query log

Modify Configuration Method One (temporary, restart mysqld after automatic recovery ):

Set global Log_slow_queries=on;set global slow_launch_time=10;

Modify Configuration Method Two (permanent):

Add a Binlog configuration under My.cnf [mysqld] (note that it must be added under [mysqld], if not in [Mysqld_safe] or other locations), configure as follows:

log-slow-queries=/var/log/mysqld-slow.loglong_query_time=2

The first configuration is the log file location, the second configuration is the time configuration of the slow query (in seconds), and query statements that execute longer than this time are recorded

Mysqldump Backup report binlogging on server not active resolution