date="$(date +"%Y-%m-%d")"
mysqldump -u root -h localhost -p‘shiheng*7D‘ hxingxing | gzip -9 > "/root/mysql-backup/hxingxing-$date.gz"

01 1 * * * root /root/mysql-backup/hxingxing-bak.sh

脚本: mysql备份远程数据库并清除一个月之前的数据