Mariadb/Mysql binlog大全--継続的な更新

デフォルトではMariadb/Mysql構成では有効になっていません
構成の変更:vim/etc/my.cnf
追加:log_bin = mysql-bin # binlog_format = mixed # expire_logs_days = 30 # 。 0, " "
#cat/etc/my.cnf | egrep 'log[_-]bin|binlog_format|expire_logs_days' の
binglogが されていない formatフォーマット、set session binglog_を できますformat=''とset global binglog_format=''オンライン
show global variables like 'log_bin';==> に になったかどうかを
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin     | ON   |
+---------------+-------+
1 row in set (0.00 sec)
show binary logs;==> のログファイルを
+-------------------+-----------+
| Log_name       | File_size |
+-------------------+-----------+
| master_bin.000001 |     821 |
+-------------------+-----------+
1 row in set (0.00 sec)
flush logs;==>logをリフレッシュし、 しい
show master status;
+-------------------+----------+--------------+------------------+
| File        | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| master_bin.000002 |    608 |         |            |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
reset master;==>ロゴを にして、
Query OK, 0 rows affected (0.03 sec)
show master status;
+-------------------+----------+--------------+------------------+
| File         | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| master_bin.000001 |    245 |         |            |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
show binlog events in 'master_bin.000001'G=>binlogコンテンツのクエリー
*************************** 1. row ***************************
   Log_name: master_bin.000001
        Pos: 4
 Event_type: Format_desc
  Server_id: 1
End_log_pos: 245
       Info: Server ver: 5.5.44-MariaDB-log, Binlog ver: 4
*************************** 2. row ***************************
   Log_name: master_bin.000001
        Pos: 245
 Event_type: Query
  Server_id: 1
End_log_pos: 332
       Info: use `school`; truncate table teacher
2 rows in set (0.00 sec)
またはmysqlbinlog--start-date=「2016-02-28 00:00:00」--stop-date=「2016-02-29 00:00:00」master_bin.000001 のクエリでpositonを に