自动备份的小脚本

#!/bin/sh
###################
#
#Author:David.cui
#Date:  2019-07-04
#Version:V0.1
#
####################

if [ $# -ne 1 ]; then
     echo "Usage:"
     echo "auto_back_db.sh dbname"
     exit
fi

db=$1
mkdir $db
cd $db

dbschema -d $db -ss -it DR > $db.sql
echo "unload to $db.data.sql delimiter ';' select 'unload to '||tabname||'.unl select * from '||tabname from systables where tabid>99 and nrows<1000000;"|dbaccess $db
dbaccess $db $db.data.sql