#!/bin/bash DBNAME="XXXX" HOST="xx.xxx.xxx.xx" #ftp 远程 地址USER="xxx" #ftp 用户名PASS="xxxxxxx" # ftp密码BACKDIR="/daybakup/"DB2USER="XXXX" #数据库管理用户if [ -a "$BACKDIR" ]; thenchmod a+w $BACKDIR cp --reply=yes ./back.s...
显示全部
#!/bin/bash
DBNAME="XXXX"
HOST="xx.xxx.xxx.xx" #ftp 远程 地址
USER="xxx" #ftp 用户名
PASS="xxxxxxx" # ftp密码
BACKDIR="/daybakup/"
DB2USER="XXXX" #数据库管理用户
if [ -a "$BACKDIR" ]; then
chmod a+w $BACKDIR
cp --reply=yes ./back.sh $BACKDIR
chmod a+x $BACKDIR
else
mkdir $BACKDIR
chmod a+w $BACKDIR
chmod a+x $BACKDIR
fi
su - $DB2USER -c $BACKDIR
year=`date +%Y`
month=`date +%m`
day=`date +%d`
now=$year-$month-$day
cd $BACKDIR
mkdir $now
cd $now
db2 backup db $DBNAME online incremental to .;
tar -zcf $DBNAME.$now.tar.gz $DBNAME.*
ftp -vn $HOST << EOC
user $USER $PASS
!cd $BACKDIR
put $DBNAME.$now.tar.gz
bye
收起