批量导出和导入informix表结构和数据

informix@ER1 ~ >cat db_unload.sh 
#!/bin/sh
#
#Author:David.cui
#

if [ $# -ne 2 ]; then
    echo "Usage: "
    echo "db_unload.sh 'dbname' 'backup_dir'"
    exit
fi

dbname=$1
bakdir=$2
mkdir -p $bakdir/$dbname
cd  $bakdir/$dbname
dbschema -d $dbname -ss > $dbname.sql
echo "unload to tab.unl delimiter ' ' select tabname from systables where tabid>99 and tabtype='T';"|dbaccess  $dbname
cat tab.unl|while read line; do 
echo "unload to $line.unl select * from $line;"|dbaccess $dbname;
done
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

informix@ER1 ~ >cat db_load.sh 
#!/bin/sh
#
#Author:David.cui
#

if [ $# -ne 2 ]; then
    echo "Usage: "
    echo "db_load.sh 'dbname' 'backup_dir'"
    exit
fi

dbname=$1
bakdir=$2
cd $bakdir/$dbname

dbaccess $dbname $dbname.sql
cat tab.unl|while read line; do 
echo "load from  $line.unl insert into $line;"|dbaccess $dbname;
done
 

导入脚本的缺陷：

1、如果有外键约束的情况下，无法正常处理，需要手工干预