mysql备份脚本
2017-10-18 本文已影响0人
944f671bfb68
#!/bin/bash
DB=(dbname1 dbname2)
Date= 'date +%F-%H'
DB_File="mysql_db_$Date"
Backup_Path=/data/backup
MysqlDump= 'which mysqldump'
[ -z $MysqlDump ] && echo 'not find mysqldump !' && exit
Backup_Bin=$MysqlDump' -uroot -p123 --extended-insert=false -B '
#echo $Backup_Bin
cd $Backup_Path
for db in ${DB[@]}
do
$Backup_Bin $db > $db.sql
done
tar -zcf $DB_File.tar.gz *.sql &> /dev/null
rm -rf *.sql &> /dev/null
crontab -e添加脚本
