备份脚本:
#!/bin/sh
hadd="目标IP"
user="mysql user name"
pd="mysql pwd"
db="dbname"
split="_"
day=`date +%Y%m%d_%H%M%S`
cd /backup/data
mysqldump -h${hadd} -u${user} -p${pd} ${db} >${db}${split}${day}.sql
自动备份命令:
crontab -e
* 3 * * * /root/back.sh
每天3点自动备份