数据库备份shell

hdb5518

各位大侠：
   帮忙弄一个sybase 的  unix平台上 shell  备份数据库程序，咋样清理逻辑
日志空间？

youzhipiao

创建bakcup_db文件
#!/usr/bin/ksh

rq=`date '+%y%m%d'`
cd /opt/sybase/db_backup
rm master*.dmp

user="sa"
passwd=""
dumppath="/opt/ssybase/db_backup"
dumpfile=$dumppath/master_$rq.dmp

SYBASE="/opt/sybase"
SYBASE_ASE=$SYBASE/ASE-12_0
SYBASE_OCS=$SYBASE/OCS-12_0
DSQUERY=HAHA
export SYBASE DSQUERY SYBASE_ASE SYBASE_OCS

PATH=$PATH:/usr/sbinSYBASE/binSYBASE_ASE/installSYBASE_OCS/binSYBASE/util/bin
export PATH

LD_LIBRARY_PATH=$SYBASE_OCS/libSYBASE_ASE/lib;
export LD_LIBRARY_PATH

# can't edit below
/opt/sybase/OCS-12_0/bin/isql -U$user -P$passwd -SHAHA -o $dumppath/back_master.out<<!!
select getdate()
go
dump database master to "$dumpfile"
go
select getdate()
go
!!
crontab中把这个脚本加入即可。