数据库备份
- 执行 db_dump.sh westos( 数据库密码 )
- 脚本执行后会备份数据库中的所有库到 /mnt/mysqldump 目录中,备份文件名称为 “库名称 .sql” 当此文件存在时报错并询问动作,输入“ S” 跳过备份,当输入“ B" 时备份“库名称 .sql” 文件为“库名称 _backup.sql”,当输入“ O” 时,覆盖源文件。
主要思路:
1.判定数据库服务的状态
2.判定密码是否正确
3.判定目录/mnt/mysqldump有没有
4.判定备份文件 库名称.sql存不存在 存在询问 不存在
#!/bin/bash
if [ ! -e "/var/lib/mysql/mysql.sock" ]
then
echo "Error: Mysql is not running"
exit 1
elif [ -z "$1" ]
then
echo "Error: Please show db password following $0"
exit 1
fi
mysql -uroot -p$1 -e "show databases;" &> /dev/null
if [ "$?" -ne "0" ]
then
echo "Error: Wrong password for db!!"
exit 1
fi
[ -e "/mnt/mysqldump" ]||{
mkdir -p /mnt/mysqldump
}
All_DB=`mysql -uroot -plee -NE -e "SHOW DATABASES;" | sed '/^*/d;/schema$/d'`
Action_Choose()
{
read -p "Please input your action: " ACTION
case $ACTION in
S|s|Skip|skip)
;;
B|b|Backup|backup)
mv /mnt/mysqldump/${DBNAME}.sql /mnt/mysqldump/${DBNAME}_backup.sql
mysqldump -uroot -p$1 $DBNAME > /mnt/mysqldump/${DBNAME}.sql
;;
O|o|overwrite|Overwrite)
mysqldump -uroot -p$1 $DBNAME > /mnt/mysqldump/${DBNAME}.sql
;;
*)
echo "Error: Wrong action please input s|o|b|"
Action_Choose
esac
}
for DBNAME in $All_DB
do
if [ -e "/mnt/mysqldump/${DBNAME}.sql" ]
then
echo "$DBNAME's backupfile is exist!!"
echo "You can choose your action"
echo "[S]kip [B]ackup [O]verwrite"
Action_Choose $1
else
mysqldump -uroot -p$1 $DBNAME > /mnt/mysqldump/${DBNAME}.sql
echo "$DBNAME is backup in /mnt/mysqldump/${DBNAME}.sql"
fi
done
安装mariadb服务,进行安全初始化
执行结果: