Dump one table

text

.dump users

Explanation

Useful when sharing a fixture or moving just one logical dataset.

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 Move data in and out

Set shell parsing options before import.

Open In sheettextsame section

Write selected rows to a CSV file.

Open In sheettextsame section

Execute inserts and DDL from a seed script.

Open In sheetbashsame section

Create a backup from inside sqlite3.

Open In sheettext1 tag match

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

Rebuild the database file and reclaim free space.