sqlite dump specific table
$ sudo apt-get install sqlite3 libsqlite3-dev
---------- dump specific tables ----------
$ sqlite3
sqlite> .open db.sqlite
sqlite> .output schoolAttendance_student.sql
sqlite> .dump schoolAttendance_student
---------- dump all tables ----------
sqlite> .dump
---------- restore db from sql ----------
$ sqlite3 db.sqlite < schoolAttendance_student.sql
---------- shrink db size ----------
sqlite> VACUUM
---------- From bash ----------
$ sqlite3 db.sqlite .schema > schema.sql
$ sqlite3 db.sqlite .dump > dump.sql