mysql> show binary logs;
mysql> show master status ;
mysql> show binlog events in 'binlog.000007';
[root@db01 data]# mysqlbinlog binlog.000007
[root@db01 data]# mysqlbinlog --base64-output=decode-rows -vvv binlog.000007
3.4.2 数据损坏模拟和恢复
故障模拟:
mysql>flush logs;Query OK,0rows affected (0.01 sec)
mysql> show master status ;+---------------+----------+--------------+------------------+-------------------+| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |+---------------+----------+------------