Use the shell backup command

text

.backup backup.db

Explanation

A convenient shell-level backup path for local workflows.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Backup and maintenance

Write a fresh copy of the database to a new file.

Open In sheetsqlsame section

Rebuild the database file and reclaim free space.

Open In sheetsqlsame section

Verify the database structure and content consistency.

Open In sheetsqlsame section

Set shell parsing options before import.

Open In sheettext1 tag match

Write selected rows to a CSV file.

Open In sheettext1 tag match

Export only selected table schema and data.

Open In sheettext1 tag match