查看log-bin是否开启:
mysql> show variables like '%log%bin%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| sql_log_bin | ON |
+---------------------------------+-------+
3 rows in set (0.00 sec)
用sakila数据库测试:
mysql> use sakila;
Database changed
查看表内容:
mysql> select * from yoon;
+----+------+
| id | name |
+----+------+
|1 | yoon |
|7 | aaa |
mysql> show variables like '%log%bin%';
+---------------------------------+-------+
| Variable_name
+---------------------------------+-------+
| log_bin
| log_bin_trust_function_creators | OFF
| sql_log_bin
+---------------------------------+-------+
3 rows in set (0.00 sec)
用sakila数据库测试:
mysql> use sakila;
Database changed
查看表内容:
mysql> select * from yoon;
+----+------+
| id | name |
+----+------+
|
|