Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/Attempt recovery from a damaged database

Use the shell recovery command.

Back to sheetBrowse commands
Sign in to save
Section: Output, import, and export

Attempt recovery from a damaged database

text
text
.recover
Explanation

Can salvage data from a corrupt database into SQL output for rebuilding.

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 Output, import, and export
Show column headers
Enable headers in tabular output.
OpenIn sheettextsame section
Use aligned column output
Render query results in a readable table.
OpenIn sheettextsame section
Export rows as CSV
Switch output mode to CSV.
OpenIn sheettextsame section
Import a CSV file into a table
Load rows from CSV using the shell importer.
OpenIn sheettextsame section
Execute SQL from a file
Run a script inside the shell.
OpenIn sheettextsame section
Dump the full database as SQL
Export schema and data as executable SQL.
OpenIn sheettextsame section