mysql数据库备份脚本

2019独角兽企业重金招聘Python工程师标准>>>

#!/bin/bash

 

fullDate=`date +"%F_%H.%M.%S"`

backdir=/root/backup

 

mysqldump smartcampus -u root -pWanda-2009 --hex-blob --add-drop-table > ${backdir}/backup${fullDate}.sql;

cd /root/backup

tar zcvf backup${fullDate}.tar.gz backup${fullDate}.sql --remove-files;

 

# 等到时间到了再过来试试看  删除

find ${backdir?no path} -mtime +2 -name "backup*.tar.gz" -exec rm -rf {} \;

 

 

mysqldump donut -u root -pa123456 --hex-blob --add-drop-table > donut.sql;

cd /root/backup

转载于:https://my.oschina.net/maliang9527/blog/3039443