# flashback 标签
首先查看当前binlog位点文件，记录下当前binlog文件编号mysql-bin.000090 mysql> show master status; +------------------+-----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+-----------+--------------+------------------+-------------------+ | mysql-bin.000090 | 124426364 | | | | +------------------+-----------+--------------+------------------+-------------------+ 1 row in set (0.00 sec) mysql> 根据sql修改大致时间段....

基于mysql的binlog还原sql及flashback对应sql语句