linux下 mysql自动备份脚本

#!/bin/sh
# File: /home/mysql/backup.sh
# Database info

DB_USER="root" 
DB_PASS="1234"

# Others vars
BIN_DIR="/usr/bin/"
BCK_DIR="/home/soft/mysql/backup/"
DATE=`date +%F`

# TODO
$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS cityapp | gzip > $BCK_DIR/db_cityapp_$DATE.gz
$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS cutemonitor | gzip > $BCK_DIR/db_cutemonitor_$DATE.gz