SQLite Basics

Create Database

To create new database run:

sqlite3 <new db name>

SQLite Shell Commands

Dump

To export database content in sql file:

$sqlite3 testDB.db .dump > testDB.sql

To perform opposite operation and restore database from sql dump file:

$sqlite3 testDB.db < testDB.sql