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

最新推荐文章于 2023-06-01 15:30:17 发布

原创最新推荐文章于 2023-06-01 15:30:17 发布 · 2.2k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#批量导出

informix技术专栏收录该内容

226 篇文章

订阅专栏

本文介绍了一组用于 Informix 数据库的卸载和加载操作的 shell 脚本，包括 db_unload.sh 和 catdb_load.sh。这些脚本允许用户将数据库内容卸载到文件中，并在需要时重新加载。然而，脚本存在一些限制，如在外键约束存在的情况下可能需要手动干预。

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、如果有外键约束的情况下，无法正常处理，需要手工干预