[root@db01 scripts]#cat 01-mysql-bak.sh 

#!/bin/bash

. /etc/init.d/functions

DATE=$(date +%F)

DB_DIR=/backup/mysql/${DATE}

for database in $(mysql -uroot -pzyh123.com -e "show databases;" |sed 1d |egrep -v "*_schema")

do

	if [ ! -d ${DB_DIR}/${database} ];then

		mkdir -p "${DB_DIR}/${database}"

	fi

	for table in $(mysql -uroot -pzyh123.com -e "use ${database};show tables;"|sed 1d)

	do

		mysqldump -uroot -p'zyh123.com' -B ${database} ${table} > ${DB_DIR}/${database}/${table}.sql

		if [ -f ${DB_DIR}/${database}/${table}.sql ];then

			action "${DB_DIR}/${database}/${table}.sql 备份成功" /bin/true 

		else

			action "${DB_DIR}/${database}/${table}.sql 备份失败" /bin/false

		fi

	done

done