#!/bin/bash
# dump
cat >/tmp/a.$$.sql <<-SQL
.output /tmp/bstopdb.sql
.dump
.exit
SQL
#
cat /tmp/a.$$.sql | sqlite3 /tmp/bstopdb
# dump
cat >/tmp/a.$$.sql <<-SQL
.output /tmp/estatdb.sql
.dump
.exit
SQL
#
cat /tmp/a.$$.sql | sqlite3 /tmp/estatdb
# dump
cat >/tmp/a.$$.sql <<-SQL
.output /tmp/ipadicdb.sql
.dump
.exit
SQL
#
cat /tmp/a.$$.sql | sqlite3 /tmp/ipadicdb
# dump
cat >/tmp/a.$$.sql <<-SQL
.output /tmp/quotedb.sql
.dump
.exit
SQL
#
cat /tmp/a.$$.sql | sqlite3 /tmp/quotedb
# dump
cat >/tmp/a.$$.sql <<-SQL
.output /tmp/zipdb.sql
.dump
.exit
SQL
#
cat /tmp/a.$$.sql | sqlite3 /tmp/zipdb
# dump
cat >/tmp/a.$$.sql <<-SQL
.output /tmp/stldb.sql
.dump
.exit
SQL
#
cat /tmp/a.$$.sql | sqlite3 /tmp/stldb
# dump
cat >/tmp/a.$$.sql <<-SQL
.output /tmp/ekidb.sql
.dump
.exit
SQL
#
cat /tmp/a.$$.sql | sqlite3 /tmp/ekidb
# dump
cat >/tmp/a.$$.sql <<-SQL
.output /tmp/osmdb.sql
.dump
.exit
SQL
#
cat /tmp/a.$$.sql | sqlite3 /tmp/osmdb
# dump
cat >/tmp/a.$$.sql <<-SQL
.output /tmp/rdataset.sql
.dump
.exit
SQL
#
cat /tmp/a.$$.sql | sqlite3 /tmp/rdataset
# load
cat >/tmp/a.$$.sql <<-SQL
.read /tmp/bstopdb.sql
.read /tmp/estatdb.sql
.read /tmp/ipadicdb.sql
.read /tmp/quotedb.sql
.read /tmp/zipdb.sql
.read /tmp/stldb.sql
.read /tmp/ekidb.sql
.read /tmp/osmdb.sql
.read /tmp/rdataset.sql
vacuum;
.exit
SQL
#
rm -f /tmp/alldb
cat /tmp/a.$$.sql | sqlite3 /tmp/alldb