SQLite 3 · Import, export and backup
Make a binary backup
Copy the database to a file safely, even while it is in use.
.backup backup.db
Official SQLite 3 documentation
More import, export and backup commands
- Import a CSV file
- Export a query to CSV
- Dump the database as SQL
- Restore from a SQL dump
- Run a SQL script
All import, export and backup commands · SQLite 3 cheatsheet