#!/bin/bash
#sirt data backup shell,execute at everyday 23:00
#use crontab -l command to have a look
## define parameters
#export PATH=/usr/local/mysql5/bin:$PATH
c_time=$(date +%Y%m%d)
old_bak=`date --date='30 days ago' +%Y%m%d`
backuphome="/usb/andacms_backup"
#backup sql files
mkdir $backuphome/$c_time
cd $backuphome/$c_time
echo "start backup database sql files to localhost"
mysqldump -uroot -pmysql57@sirt123ABC -e --net_buffer_length=8192 andacms_sirt>andacms_sirt.sql
mysqldump -uroot -pmysql57@sirt123ABC -e --net_buffer_length=8192 report>report.sql
mysqldump -uroot -pmysql57@sirt123ABC -e --net_buffer_length=8192 sirt_recruit>sirt_recruit.sql
tar czf db.tar.gz *.sql
tar czf /data/webroot/db.tar *.sql
rm -rf *.sql
scp db.tar.gz root@192.168.71.247:/data/backup/
echo "backup database sql files to localhost successfully"
tar cf andacms.tar /data/webroot/andacms
scp andacms.tar root@222.30.160.24:/data/backup/
##remove localhost old files
cd $backuphome
rm -rf $old_bak
CentOS6.8备份脚本
最新推荐文章于 2022-08-11 18:27:47 发布