MySQL备份脚本

docker MySQL

#!/bin/sh
DB_USER="user"
DB_PASS="password"
DB_NAME=(databases1 databases2 databases3)
# Others vars
BCK_DIR="备份路径"
DATE=`date +%F`
# TODO
for DB_NAME in ${DB_NAME[*]}
do
  docker exec mariadb mysqldump --opt -u$DB_USER -p$DB_PASS $DB_NAME | gzip > $BCK_DIR/$DB_NAME$DATE.sql.gz
done
find $BCK_DIR/* -mtime +30 -exec rm { } \;

MySQL

#!/bin/sh
DB_USER="user"
DB_PASS="password"
DB_NAME=(databases1 databases2 databases3)
BIN_DIR="/usr/bin"
BCK_DIR="备份路径"
DATE=_`date +%F`
for DB_NAME in ${DB_NAME[*]}
do
  $BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS $DB_NAME | gzip > $BCK_DIR/$DB_NAME$DATE.sql.gz
done
find $BCK_DIR/* -mtime +30 -exec rm { } \;