Incremental backup
cp/var/lib/mysql/mysql-bin*/tmp/
Back up the MyBlog database and clear the data about MyBlog in the incremental backup
Mysqldump--flush-logs-uroot-p Han >/tmp/myblog.sql
Back up all databases, clear incremental backups
Mysqldump--flush-logs-u root-p--all-databases >/tmp.all.sql
View Binlog content for a specified time
Ysqlbinlog--start-date= "2016-5-7 20:00:00"--stop-date= "2016-5-7 20:30:00"/tmp/mysql-bin.000001
Specify time period Recovery
Mysqlbinlog--start-date= "2016-5-7 20:00:00"--stop-date= "2016-5-7 20:30:00"/tmp/mysql-bin.000001 |mysql-uroot- P123.com
Specify Time Recovery
Mysqlbinlog--stop-date= "2016-5-7 20:00:00"/tmp/mysql-bin.000001 |mysql-uroot-p123.com
View database dynamics after a specified time recovery
Mysqlbinlog--start-date= "2016-5-7 20:00:00"/tmp/mysql-bin.000001 |mysql-uroot-p123.com
Http://blog.51yip.com/mysql/1042.html
Http://www.111cn.net/database/mysql/58386.htm
Http://www.centoscn.com/mysql/2015/0204/4630.html
This article from "No Trace" blog, reproduced please contact the author!
Mysqlbinlog Incremental backup and recovery