# 导出binlog数据到文件 mysqlbinlog --no-defaults mysql-bin.000001 -d [database] -v -v > mysql-bin.000001.sql # 导入数据到MySQL mysql -uroot -p[password] [database] < mysql-bin.000001.sql
数据恢复文章
mysql binlog介绍以及通过binlog实现数据恢复
报错
ERROR 1609 (HY000): The BINLOG statement of type `Table_map` was not preceded by a format description BINLOG statement.
在报错的语句之前执行下
BINLOG ' bTXkUw8KAAAAdQAAAHkAAAABAAQANS42LjE5LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXQAEGggAAAAICAgCAAAACgoKGRkADQEe sjFX '/*!*/; # 这是一个Format_description_event
参考