mysql 数据备份脚本

#!/bin/sh

# Database info
DB_USER="root"
DB_PASS="root"
DB_HOST="localhost"
DB_NAME="test"

# Others vars
BIN_DIR="/home/mysql/bin"            #the mysql bin path
BCK_DIR="/home/buckup"               #the backup file directory
DATE=`date +%F`

$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS -h$DB_HOST $DB_NAME  | gzip > $BCK_DIR/db_$DATE.sql.zip