爱程序网

Linux下mysql自动备份

来源: 阅读:

#!/bin/bash
DATE=`date +%Y-%m-%d-%H:%M -d -3minute`
USER=root
PASSWORD=maybo
BACKUP_DIR='/home/mysqlbak/'
LOG_DIR='/home/mysqlbak/mysqlbak_log.log'
DATABASES='BBS'
if [ ! -d $BACKUP_DIR ];then
mkdir -p $BACKUP_DIR
fi
echo -e "\n" >> $LOG_DIR
echo -e "----------------------------------------------------------" >> $LOG_DIR
echo -e "BACKUP DATA:$DATE" >> $LOG_DIR
echo -e "----------------------------------------------------------" >> $LOG_DIR
cd $BACKUP_DIR
for name in $DATABASES;do
mysqldump -u$USER -p$PASSWORD -R $name > $BACKUP_DIR$DATE'_'$name'.sql'
if [ $? == 0 ];then
echo $BACKUP_DIR$DATE'_'$name'.sql BACKUP SUCCESS.' >> $LOG_DIR
else
echo $BACKUP_DIR$DATE'_'$name'.sql BACKUP FAIL.' >> $LOG_DIR
fi
done

关于爱程序网 - 联系我们 - 广告服务 - 友情链接 - 网站地图 - 版权声明 - 人才招聘 - 帮助