学步园

#!/bin/sh
# 文 件 名: rptsmain.sh
# 版    权: Copyright (shell) 2007-2007 
# 版 本 号: V1.0
# 功能描述:  数据备份
# 创 建 人: xxxxx
# 日    期: 2007/10/26
# 修 改 人:xxxxxxx
# 日    期: 2007/10/26

#程序开始

TODAY=`date "+%Y%m%d"`
WORKDATE=$TODAY
BACKDIR='/databak/'

tput init
clear
while :
do
tput clear

echo ""
echo ""
echo ""
echo ""
echo ""
echo ""
echo ""
echo ""
echo ""
echo "
                                   数据备份程序 V1.0
           
                                   Copyright (shell) 
    
  ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
  ┃                                                      ┃
  ┃                 1.     开始备份数据                  ┃
  ┃                                                      ┃
  ┃                 2.     备份数据写入磁带              ┃
  ┃                                                      ┃
  ┃             ----------------------------------       ┃
  ┃                                                      ┃
  ┃                 0.     退出系统                      ┃
  ┃                                                      ┃
  ┗━━━━━━━━━━━━━━━━━━━━━━━━━━━┛
  
                            请选择[  ] "

read choice
 case $choice in
  1):
   clear
   
   echo "开始BCP数据库数据..."
   DATABASEDIR=$BACKDIR/database
   if [ -d $DATABASEDIR ]; then
    rm -rf $DATABASEDIR/*
   else    
    mkdir $DATABASEDIR
   fi
   
   #备份webdb数据库
   mkdir $DATABASEDIR/webdb
   total=`cat webdb.table|wc -l`   
   current=0                   
   for table in `cat webdb.table`
    do 
     current=$current+1 
     /sybase/OCS-12_5/bin/bcp webdb..$table out

$DATABASEDIR/aadb/$table.bcp -Usa -Ppwd -SServer -Jiso_1 -n -T409600
    done
    
   #备份abcdb数据库
   mkdir $DATABASEDIR/abcdb
   total=`cat abcdb.table|wc -l`   
   current=0                   
   for table in `cat abcdb.table`
    do 
     current=$current+1 
     /sybase/OCS-12_5/bin/bcp abcdb..$table out

$DATABASEDIR/bbdb/$table.bcp -Usa -Ppwd -SServer -Jiso_1 -n -T409600
    done
   
   echo "开始打包压缩数据库备份数据..." 
   cd $BACKDIR
   tar uvf database-$WORKDATE.tar database/*
   
   echo "正在删除临时文件..." 
   rm -rf $DATABASEDIR
   
   
   
   echo "开始打包压缩数据文件..."   
   echo "(1)开始打包Tomcat-ABC网站数据文件..."
   SOuRCEDIR='/aaaa/uploads'
   cd $BACKDIR
   #tar czf abc-files-$WORKDATE.tar.gz $SOuRCEDIR/ISO/*
   
   echo "(2)开始打包Websphere经管网数据文件..."
   cd $BACKDIR
   #tar czf web-files-$WORKDATE.tar.gz /upload/images/807/*
   
   echo "数据备份完成，按任意键返回..."
   cd $HOME
   read return
   ;;
  2):
   ;;
  0):
   break
   ;;
  esac
  done