What should I do if mysql fails to set log-bin?

The solution to the failure of mysql to set “log-bin”: first modify the [my.cnf] file; then store the log file in binary form; finally find the binary file and use the command to export it. 【Related learning recommendation: mysql tutorial(video)】 The method to solve the failure of mysql to set log-bin: 1. Modify the my.cnf file log-bin=mysql-bin binlog_do_db=hello log-bin: Setting this parameter means enabling the binlog function and specifying the path name binlog_do_db: Specify the database name for logging After modifying the file, you need to restart the database service 2 . The log file exists in binary form, find the binary file, and use the command to export a) Find the storage location of the binary file [root@CCDT-gluster-1 mysql]# ps -ef | grep mysql root 12017 1 0 13:45 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe –datadir=/home/Mysql/MysqlData –pid-file=/home/Mysql/MysqlData/mysql1. pid mysql 12336 12017 0 13:45 pts/0 00:00:02 /usr/sbin/mysqld –basedir=/usr –datadir=/home/Mysql/MysqlData –plugin-dir=/usr/lib64/mysql/ plugin –user=mysql –log-error=/home/Mysql/MysqlData/CCDT-gluster-1.err –pid-file=/home/Mysql/MysqlData/mysql1.pid root 14080 26031 0 13:50 pts/0 00:00:00 grep mysql root 20668 1 0 May11 ? 00:00:00 mysql -u root -p b) The binary file is stored in the directory where the database file is located, use the mysqlbinlog command to export [root@CCDT-gluster-1 mysql]# cd /home/Mysql/MysqlData [root@CCDT-gluster-1 MysqlData]# mysqlbinlog…