sqlite3 myapp.db .dump > backup.sql

Category: Self-Hosting

sqlite3 myapp.db .dump > backup.sql

Export an SQLite database to a SQL text dump — SQLite is used by many lightweight self-hosted apps

Exports an SQLite database to SQL text. SQLite is used by many lightweight self-hosted apps including FreshRSS, Gitea (optional), and Home Assistant.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.