mysql binlog恢复某个库某张表_使用mysqlbinlog恢复指定表

一、登录数据库刷新binlog1.1)查看当前的binlog

MySQL>show master status;

+---------------------+----------+--------------+------------------+-------------------+

| File                | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

+---------------------+----------+--------------+------------------+-------------------+

| test-150-bin.000003 |  2895377 |              |                  |                   |

+---------------------+----------+--------------+------------------+-------------------+

1 row in set (0.00 sec)

1.2)刷新binlog

mysql>flush logs;

Query OK, 0 rows affected (0.01 sec)

1.3)确认刷新binlog成功

mysql> show master status;

+---------------------+----------+--------------+------------------+-------------------+

| File