Sqlite Dump

A good way to make an archival copy of a database is this:

$ echo '.dump' | sqlite3 ex1 | gzip -c >ex1.dump.gz



http://www.sqlite.org/sqlite.html