MySQL备份脚本
#!/bin/bash
mysqldump -uroot -A -E -R -F --triggers --default-character-set=utf8 --source-data=2 --single-transaction --flush-privileges |gzip > /backup/mysql/backup_`date +%F`.sql.gz
sshpass -p 123456 scp -pro StrictHostKeyChecking=no /backup/mysql/backup_`date +%F`.sql.gz 10.0.0.101:/backup/mysql/
将脚本放在/usr/local/bin/下,写入计划任务每日执行一次即可完成本地备份又可将备份数据发送到远程服务器
#!/bin/bash
for i in `mysql -uroot -e 'show databases'|grep -Ev '^Database|information_schema|performance_schema|sys'`;do
mysqldump -B $i |gzip > /backup/mysql/$i-`date +%F`.sql.gz
sshpass -p 123456 scp -pro StrictHostKeyChecking=no /backup/mysql/$i-`date +%F`.sql.gz 10.0.0.101:/backup/mysql/
done
这个是将每个数据库单独备份,并将备份数据发送到远程服务器