crontab部署mysqldump

#!/bin/bash

DB_NAME="test"

DB_USER="username"

DB_PASS="password“

BIN_DIR="/usr/local/mysql/bin"

BCK_DIR="/home/mysql/backup"

DATE=`date+%F`

$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS $DB_NAME|gzip>$BCK_DIR/db_$DATE.gz