linux下mysql开启二进制
mysql> show variables like '%log_bin%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_bin_trust_routine_creators| OFF |
| sql_log_bin | ON |
+---------------------------------+-------+
#vi /etc/my.cnf
在的下面加入下面代码：
log-bin=mysql-bin
重启mysqlservice mysqld restart
mysql> show variables like '%log_bin%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_bin_trust_routine_creators| OFF |
| sql_log_bin | ON |
+---------------------------------+-------+
页:
[1]