vim /home/mysql/backup/crontab
1 1 */1 * * /home/mysql/backup.sh
DB_NAME="***"
DB_USER=“root”
DB_PASS="***"
BCK_DIR="/home/mysql/backup"
DATE=date +%F
BCK_FILE_NAME=/home/mysql/backup/DB_$DATE.gz
/usr/bin/mysqldump --opt -uroot -p*** yishi |gzip > $BCK_FILE_NAME