SQLite Backup and Export

.backup backup.db # backup to file
.backup main backup.db # backup main database

.output dump.sql # redirect output
.dump # dump all tables
.dump users # dump specific table
.output stdout # restore output

.mode csv # set CSV mode
.headers on # include headers
.output users.csv # redirect to file
SELECT * FROM users; # export query
.output stdout

.mode csv
.import users.csv users # import CSV to table

sqlite3 newdb.db < dump.sql # restore from SQL dump
.read dump.sql # read SQL file in SQLite

cp database.db backup.db # copy file (when not in use)