全量備份之分庫備份(shell)

mkdir /server/script

cd /server/script

vi mysql_backup_db.sh

#!/bin/sh

mysql_backup_dir=/data/mysql_backup/$(date +%F)

[ ! -d ${mysql_backup_dir} ] &&  mkdir -p ${mysql_backup_dir}

user_pass='-u root -pyeqing '

mysql_login=`mysql ${user_pass} -e "show databases"|sed '1,2d'`

for dbname in ${mysql_login}

do

  mysqldump ${user_pass} -F -B ${dbname}|gzip > ${mysql_backup_dir}/${dbname}_$(date +%F).sql.gz

done

chmod u+x mysql_backup_db.sh

./mysql_backup_db.sh

本文轉自cloves 51CTO部落格，原文連結:http://blog.51cto.com/yeqing/1589916