Automatic backup of MySQL under CentOS

Automatically backs up MySQL databases under CentOS and synchronizes the differences to other network hosts

1, add backup.sh:vim/root/mysql_backup/backup.sh under/root/mysql_backup/, then add the following code inside:

Mysqldump-uroot-p ' a123456 ' mysqltest >/root/mysql_backup/' Date +%y-%m-%d~%h:%m:%s '. bak//BACKUP Database

rsync-av/root/mysql_backup/* [Email protected]:/root/backup///diff sync backup file

2, add the plan, run the command: CRONTAB-E, and then add the following content:

* */1 * * */bin/bash/root/mysql_backup/backup.sh//hourly Run backup.sh

3. Re-run the program: Service Crond restart

PS: Before running backup.sh, you need to ensure that the local SSH key access is available 172.16.0.88

Automatic backup of MySQL under CentOS