shell脚本实现数据库备份

实验环境下，我先要配置好数据库（mariadb）
 

#!/bin/bash
[ -z "$1" ] &&{
        echo "Please input mysql's passwd"
        exit 1
}

mysql -uroot -p$1 -e "show databases;" &> /dev/null
[ "$?" != "0" ] &&{
        echo "Error:connect databases failed!"
        exit 2
}

[ -d "/mnt/mysqldump" ] || {
mkdir -p /mnt/mysqldump
}

for DATABASE in `mysql -uroot -p$1 <<EOF | grep -E "Database|schema$" -v
show databases;
EOF`

do
        [ -e "/mnt/mysqldump/${DATABASE}.sql" ] && {
        echo  "/mnt/mysqldump/${DATABASE}.sql is exist,what are you want?
        [S]kip [B]ackup [O]verwrite [e]xit"     
        read -p "Please input your choic:" Choice
        case $Choice in
        S|s)
        ;;
        B|b)
        mysql -uroot -p$1 $DATABASE > /mnt/mysqldump/${DATABASE}_bachup.sql
        ;;
        O|o)
        mysql -uroot -p$1 $DATABASE > /mnt/mysqldump/${DATABASE}.sql
        ;;
 
        e)
        exit 0
        ;;
        esac
}
        mysql -uroot -p$1 $DATABASE > /mnt/mysqldump/${DATABASE}.sql
done