mysql - 数据库自动备份脚本

mkdir /backup

vim /backup/mysql_backup.sh

内容为

#!/bin/bash
date=$(date +%Y%m%d)
/usr/local/mysql/bin/mysqldump -h localhost -uroot -p'D2#2$#@d2s433egf%$^&s' erp > /backup/databases-$date.sql

然后：

crontab -e 

00 06 * * * /bin/bash /backup/mysql_backup.sh