SQLite Backup & Restore

Backup

$ sqlite3 sample.db .dump > sample.sql

Restore

$ sqlite3 sample.db < sample.sql

Table Backup

.output back.sql

.dump table_name

.quit