查看binlog日志文件转化为原生SQL
mysqlbinlog --base64-output=decode-rows -vv /var/lib/mysql/binlog.000002-> /var/lib/mysql/backup22.sql
一.增量sql文件准备
mysqlbinlog /var/lib/mysql/binlog.000002 -> /var/lib/mysql/backup.sql(全量文件)
mysqlbinlog --start-position=1 --stop-position=2 /var/lib/mysql/binlog.000002 -> /var/lib/mysql/backup.sql
二.执行文件
mysql -u root -p < backup.sql