查看全量备份后的binlog点位
mysqldump点位:解压后在sql文件前几行可找到
innobackupex点位:解压后在xtrabackup_binlog_info文件可找到
(如:mysql-bin3306.000006 154)
则需要解析mysql-bin3306.000006文件之后所有的binlog文件到sql然后导入数据库
如:(mysql-bin3306.000006、154)(mysql-bin3306.000007)
mysqlbinlog --no-defaults --base64-output=decode-rows -vv --start-position=154 /opt/software/percona5.7.29/logs/mysql-bin3306.000006 > /tmp/6.sql
mysqlbinlog --no-defaults --base64-output=decode-rows -vv /opt/software/percona5.7.29/logs/mysql-bin3306.000007 > /tmp/7.sql
按顺序将6.sql和7.sql导入mysql
mysql -u’root' -p'*******' --socket=/tmp/mysql.sock < /tmp/6.sql
mysql -u’root' -p'*******' --socket=/tmp/mysql.sock < /tmp/7.sql