SQLite 3 · Import, export and backup
Dump the database as SQL
Write the schema and data as SQL statements.
sqlite3 app.db .dump > backup.sql
Official SQLite 3 documentation
More import, export and backup commands
All import, export and backup commands · SQLite 3 cheatsheet