mysql automatic incremental backup of the instance method of local backup and remote backup

1. Local backup
Write automatic backup scripts:
vim /var/lib/mysql/autobak
It reads as follows:

cd /data/home/mysqlbak
rq=` date +%Y%m%d `
/usr/local/mysql/bin/mysqldump sqldb --flush-logs -uroot -p123456 --opt > 777city_$rq.sql

Save to exit.

chmod -777 /var/lib/mysql/autobak

crontab -e
00 00 * * * /var/lib/mysql/autobak
The autobak script is automatically executed early every night.
/etc/init.d/crontab restart

Run the script 1 manually to see what it looks like.
./var/lib/mysql/autobak
ls /data/home/mysqlbak

Take a look at the file size
du -sh /data/home/mysqlbak/777city11.sql

2. Remote database backup
Remote backup command:

/usr/local/mysql/bin/mysqldump sqldb --flush-logs -uroot -p'123456' -h'10.241.92.172' --opt > /root/777city22.sql

Automatic remote backup:
Backup the mysql database on the ip: 67 machine, ip: 172 server
Operating on ip: 67 machines:
1. Write automatic backup script:
vim /var/lib/mysql/autobak
It reads as follows:

cd /data/home/mysqlbak
rq=` date +%Y%m%d `
/usr/local/mysql/bin/mysqldump sqldb --flush-logs -uroot -p'123456' -h'10.241.92.172' --opt > 777city_$rq.sql

Save to exit.

chmod -R 777 /var/lib/mysql/autobak

crontab -e
00 00 * * * /var/lib/mysql/autobak
The autobak script is automatically executed early every night.
/etc/init.d/crontab restart

Run the script 1 manually to see what it looks like.
/var/lib/mysql/autobak
ls /data/home/mysqlbak

Take a look at the file size
du -sh /data/home/mysqlbak/777city11.sql