shell MySql数据库备份

#!/bin/bash

user=root
password=root
backfile=/root/mysql/backup

[ ! -d $backfile ] && mkdir -p $backfile
cmd="mysql -u${user} -p${password}"
dump="mysqldump" -u$user -p$password

db_list=`$cmd -e "show databases;" 2>/dev/null | sed ld | egrep -v '_schema|mysql'`

echo "需要备份的数据库列表：
echo "$db_list

for db_name in $db_list
do
  printf "%s backing up" ${db_name}
  $dump ${db_name} 2>/dev/null | gzip > ${backfile}/${db_name}_${date +%m%d.sql.gz}
done

echo "全部备份完成！"