Linux下自动备份MySQL

MySQL自动备份

#!/bin/sh
# File: /alidata/server/mysql/backup_shell/backup.sh
# Database info
DB_NAME="数据库名"
DB_USER="用户名"
DB_PASS="密码"

# Others vars
BIN_DIR="/alidata/server/mysql/bin"
BCK_DIR="/备份到的目录"
DATE=`date +%F`

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