bash_备份mysql数据库

#!/bin/bash

if[ -z `which mysqldump`  ]; then

echo "Can not find mysqldump"

exit 1

fi

dbName="dbname1 dbnameN"

sqlUser="root"

sqlPwd="123456"

bak_dir="." #备份文件临时存放目录；

for i in $dbName

do

mysqldump -u$sqlUser -p$sqlPwd $i > $bak_dir/$(date +%y-%m-%d~%H:%M).sql

sleep 3

done

sleep 60

#将备份数据打包，并删除原备份文件；

tar --remove-files -cvzf $bak_dir/$(date +%y-%m-%d~%H:%M).tar.gz $ak_dir/*.sql 2&>1 /dev/null

exit 0