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 recommendations: mysql tutorial(Video)】

Methods to solve mysql failure 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: Specifying the name of the database for recording logs

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 it

a ) Find the binary file storage location

[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 --start-datetime='2016-11-17 12:00:00' --stop-datetime='2016-11-17 17:00:00' mysql-bin.000001 > ./hello.txt

If you want to learn more about programming, please stay tuned. php training column!

The above is the detailed content of What should I do if mysql fails to set log-bin?. For more information, please follow other related articles on the PHP Chinese website!