mysql dump备份结合binlog日志恢复讲解

查看Mysql binlog日志 

mysqlbinlog --no-defaults  iZbp1gwwsckn9afrdy0itkZ-relay-bin.000020 | grep 'CREAT DATABASE `brill_lab`'

dump方式全量备份Mysql

mysqldump -u root -p --flush-logs --master-data=1 brill_lab > /data/backup/mysql/brill_lab_20190814.sql

数据恢复

1.通过dump的sql文件恢复数据库
2.使用mysqlbinlog命令恢复最新数据

mysqlbinlog --start-position 772 --stop-position 154 ^
mysql-bin.000001 mysql-bin.000002 mysql-bin.000003 mysql-bin.000004 ^
mysql-bin.000005 mysql-bin.000006 mysql-bin.000007 mysql-bin.000008 ^
mysql-bin.000009 | mysql -u root -p brill_lab