mysql备份脚本

#!/bin/sh
#PATH=/usr/local/sbin:/usr/bin:/bin
 
# The Directory of Backup
BACKDIR=/usr/mysql_backup
# The Password of MySQL
ROOTPASS=123456
 
# Remake the Directory of Backup
rm -rf $BACKDIR
mkdir -p $BACKDIR
 
DBLIST=`ls -p /var/lib/mysql | grep / | tr -d /`
 
for dbname in $DBLIST
do
 
if [  ${dbname} == "mysql" -o ${dbname} == "test" -o ${dbname} == "information_schema" -o ${dbname} == "performance_schema"  ];then


echo "${dbname} is not dump"
else mysqldump -uroot -p$ROOTPASS $dbname>$BACKDIR/$dbname.sql

fi
done