mysql备份数据库shell脚本_MySQL备份数据库shell脚本

以下为MySQL备份数据库的sh脚本：#!/bin/bash

# Shell script to backup MySQL database

# 设置数据库连接变量

MyUSER=""# DB_USERNAME

MyPASS=""# DB_PASSWORD

MyHOST=""# DB_HOSTNAME

# 备份数据的目标目录

DEST="" # /home/username/backups/DB

# 邮件通知

EMAIL=""

# 设置多少天之后的旧文件会被删除

DAYS=3

# Linux bin执行文件路径

MYSQL="$(which mysql)"

MYSQLDUMP="$(which mysqldump)"

GZIP="$(which gzip)"

# 获取当前日期dd-mm-yyyy format

NOW="$(date +"%d-%m-%Y_%s")"

# 新建备份子目录

MBD="$DEST/$NOW/mysql"

install -d $MBD

# 忽略备份的数据库列表

SKIP="information_schema

another_one_db"

# 获取所有数据库列表

DBS="$($MYSQL -h $MyHOST -u $MyUSER -p$MyPASS -Bse 'show databases')"

# 归档数据库dump

for db in $DBS

do

skipdb=-1

if [ "$SKIP" != "" ];

then

for i in $SKIP

do

[ "$db" == "$i" ] && skipdb=1 || :

done

fi

if [ "$skipdb" == "-1" ] ; then

FILE="$MBD/$db.sql"

$MYSQLDUMP -h $MyHOST -u $MyUSER -p$MyPASS $db > $FILE

fi

done

# 归档目录，发送邮件通知，清除

cd $DEST

tar -cf $NOW.tar $NOW

$GZIP -9 $NOW.tar

echo "MySQL backup is completed! Backup name is $NOW.tar.gz" | mail -s "MySQL backup" $EMAIL

rm -rf $NOW

# 删除旧文件

find $DEST -mtime +$DAYS -exec rm -f {} \;

源脚本：https://gist.github.com/NARKOZ/642511