import/export
Show Database
sqlite>.databases
Schema
.schema COMPANY
Show Tables
sqlite> .open somedb.db
sqlite> .tables
sqlite> .schema
Dump Db
$sqlite3 testDB.db .dump > testDB.sql
$sqlite3 testDB.db < testDB.sql
Import DB
sqlite> .mode csv
sqlite>.import c:/sqlite/city.csv cities