#!/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