服务器程序和数据库的定期备份，删除，传输到其他服务器上

1、程序备份与删除
#!/bin/bash
DIRFILE=""$(date +%Y%m%d.%H%M)""
myday=`date -d"10 day ago" +"%Y%m%d"`
/bin/rm -fr /z_data_back/pro.info_tp_uc.k8.cn.$myday*
tar -czPvf /z_data_back/pro.info_tp_uc.k8.cn.$DIRFILE.tar.gz /k8/appdir/*.k8.cn 1>/z_data_back/log/info.pro.right.txt 2>>/z_data_back/log/info.pro.err.txt
2、去除部分目录的程序备份与删除，
#!/bin/bash
#tar -czvf ex.tar.gz --exclude ./data/attachment ./data
DIRFILE=""$(date +%Y%m%d.%H%M)""
tar -czvf  /z_data_back/exclude_pro.info.k8.cn.$DIRFILE.tar.gz --exclude /k8/appdir/info.k8.cn/data /k8/appdir/info.k8.cn/config  --exclude /k8/appdir/info.k8.cn/data /k8/appdir/info.k8.cn 
3、局域网内两台服务器之间传输文件
#!/bin/bash
DIRFILE=""$(date +%Y%m%d)""
scp -P 1234 /z_data_back/backup_uc_$DIRFILE* admin@9.239.94.40:/z_data_back/
scp -P 1234 /z_data_back/backup_tp_$DIRFILE* admin@9.239.94.40:/z_data_back/
scp -P 1234 /z_data_back/backup_cms_$DIRFILE* admin@9.239.94.40:/z_data_back/
scp -P 1234 /z_data_back/pro.info_tp_uc.k8.cn.$DIRFILE* admin@9.239.94.40:/z_data_back/
4、数据库sql语句的备份，压缩，删除过期的
#!/bin/sh 
USERNAME=root 
PASSWORD='' 
case "$1" in 
info_cms) BACKUP_FILE=/z_data_back/backup_cms_`date '+%Y%m%d_%H%M%S'`.sql ;;
info_tp) BACKUP_FILE=/z_data_back/backup_tp_`date '+%Y%m%d_%H%M%S'`.sql ;;
info_uc) BACKUP_FILE=/z_data_back/backup_uc_`date '+%Y%m%d_%H%M%S'`.sql ;;
 *)
        /z_data_back/shell/mysql_bak.sh info_tp
        sleep 1
        /z_data_back/shell/mysql_bak.sh info_uc
        sleep 1
        /z_data_back/shell/mysql_bak.sh info_cms
;; 
esac 
# Start backup. 
/usr/local/mysql/bin/mysqldump --opt --password='www'  -B $1 --add-drop-table -R > $BACKUP_FILE
 
# Compress backup file. 
tar -czPf $BACKUP_FILE.tar.gz $BACKUP_FILE
sleep 2
rm -fr  $BACKUP_FILE
myday=`date -d"10 day ago" +"%Y%m%d"`
/bin/rm -fr /z_data_back/backup_uc_$myday*
/bin/rm -fr /z_data_back/backup_tp_$myday*
/bin/rm -fr /z_data_back/backup_cms_$myday*
5、数据库sql语句的备份
#!/bin/sh 
USERNAME=root 
PASSWORD='' 
case "$1" in 
info_cms) BACKUP_FILE=/z_data_back/backup_cms_`date '+%Y%m%d_%H%M%S'`.sql ;;
info_tp) BACKUP_FILE=/z_data_back/backup_tp_`date '+%Y%m%d_%H%M%S'`.sql ;;
info_uc) BACKUP_FILE=/z_data_back/backup_uc_`date '+%Y%m%d_%H%M%S'`.sql ;;
 *)
        /z_data_back/shell/mysql_bak.sh info_tp
        sleep 1
        /z_data_back/shell/mysql_bak.sh info_uc
        sleep 1
        /z_data_back/shell/mysql_bak.sh info_cms
;; 
esac 
# Start backup.
/usr/local/mysql/bin/mysqldump --opt --password='www'  -B $1 --add-drop-table -R > $BACKUP_FILE