Mysql备份脚本

#!/bin/bash
backupdir=/data/backup/db/zenfinex_prod
time=`date +%Y-%m-%d-%H-%M`
if  [ ! -e  $backupdir  ];then
 mkdir  -p  $backupdir
fi

/usr/bin/mysqldump  --single-transaction --flush-logs --skip-add-drop-table   -udbprod  -p'123456'  db1  |bzip2 > $backupdir/db1$time.sql.bz2
/usr/bin/mysqldump  --single-transaction --flush-logs --skip-add-drop-table   -udbprod  -p'123456'  db2  |bzip2 > $backupdir/db2$time.sql.bz2


find $backupdir -name "db1*.sql.bz2" -type f -mtime +7 -exec rm {} \; > /dev/null 2>&1
find $backupdir -name "db2*.sql.bz2" -type f -mtime +7 -exec rm {} \; > /dev/null 2>&1