Cheat Sheet logoCheat Sheet Today
SQLite Import, Export, and Backup Cheatsheet/Run an integrity check

Verify the database structure and content consistency.

Back to sheetBrowse commands
Sign in to save
Section: Backup and maintenance

Run an integrity check

sql
sql
PRAGMA integrity_check;
Explanation

Useful before and after migrations, backup jobs, or corruption investigations.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing Backup and maintenance
Create a compact backup with VACUUM INTO
Write a fresh copy of the database to a new file.
OpenIn sheetsqlsame section
Run VACUUM
Rebuild the database file and reclaim free space.
OpenIn sheetsqlsame section
Use the shell backup command
Create a backup from inside sqlite3.
OpenIn sheettextsame section
Load data from an SQL file
Execute inserts and DDL from a seed script.
OpenIn sheetbash1 tag match
Import CSV with mode and separator
Set shell parsing options before import.
OpenIn sheettext
Export a query result to CSV
Write selected rows to a CSV file.
OpenIn sheettext