Mysqldump Full-volume + incremental backup

1. Mysqldump Full-scale backup

   Weekly execution

   Mysqldump-uroot-p--flush-logs --single-transaction --all-database >/home/1.sql

2. Incremental backup

   When an incremental backup is required

   Mysql>flush logs

   Mysql>show Master status;

   As shown mysql-bin.000005

   Backup mysql-bin.000004 can

3. When restoring, restore the full amount of backup and then restore the increment, turn off the Mysql-bin log when restoring,

   Mysql> Set Sql_log_bin=0

Mysqldump Full-volume + incremental backup