编写脚本实现自动备份数据库（这个在企业当中非常有用）

#!/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