DBA---------------------------数据库--------------------MDP自动备份

 备份

mysqldump -uroot -p123 -A -R --triggers --set-gtid-purged=OFF --master-data=2 --single-transaction|gzip > /backup/full_$(date +%F).sql.gz

 

2）截取二进制日志 vim mysql-bin.000002
-- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=753;
753  1815

mysqlbinlog --skip-gtids   --start-position=753 --stop-position=1815  /data/binlog/mysql-bin.000002 >/backup/bin.sql