1.查看是否开启binlog日志http://www.cndba.cn/hbhe0316/article/22610http://www.cndba.cn/hbhe0316/article/22610

mysql> show variables like 'log_bin%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin                         | OFF   |
| log_bin_basename                |       |
| log_bin_index                   |       |
| log_bin_trust_function_creators | OFF   |
| log_bin_use_v1_row_events       | OFF   |
+---------------------------------+-------+
5 rows in set (0.00 sec)

2.编辑/etc/my.cnf文件

log-bin=/logs/mysql-bin
binlog_format=mixed
server-id = 1
expire_logs_days=10

3.重启Mysql

[root@mysql57 ~]# service mysqld restart
Shutting down MySQL.. SUCCESS! 
Starting MySQL.. SUCCESS!

4.再次查看binlog是否开启http://www.cndba.cn/hbhe0316/article/22610http://www.cndba.cn/hbhe0316/article/22610

mysql> show variables like 'log_bin%';
+---------------------------------+-----------------------+
| Variable_name                   | Value                 |
+---------------------------------+-----------------------+
| log_bin                         | ON                    |
| log_bin_basename                | /logs/mysql-bin       |
| log_bin_index                   | /logs/mysql-bin.index |
| log_bin_trust_function_creators | OFF                   |
| log_bin_use_v1_row_events       | OFF                   |
+---------------------------------+-----------------------+
5 rows in set (0.00 sec)

5.查看/logs下是否有binlog日志生成

[root@mysql57 logs]# ll
total 136
-rw-r--r-- 1 mysql mysql 115640 Nov 27 08:10 mysql57.log
-rw-r----- 1 mysql mysql    154 Nov 27 08:10 mysql-bin.000001
-rw-r----- 1 mysql mysql     23 Nov 27 08:10 mysql-bin.index

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL