Cheat Sheet logoCheat Sheet Today
SQLite Import, Export, and Backup Cheatsheet/Load data from an SQL file

Execute inserts and DDL from a seed script.

Back to sheetBrowse commands
Sign in to save
Section: Move data in and out

Load data from an SQL file

bash
bash
sqlite3 app.db < seed.sql
Explanation

A shell-friendly way to initialize or refresh a local database.

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 Move data in and out
Import CSV with mode and separator
Set shell parsing options before import.
OpenIn sheettextsame section
Export a query result to CSV
Write selected rows to a CSV file.
OpenIn sheettextsame section
Dump one table
Export only selected table schema and data.
OpenIn sheettextsame section
Create a compact backup with VACUUM INTO
Write a fresh copy of the database to a new file.
OpenIn sheetsql1 tag match
Run VACUUM
Rebuild the database file and reclaim free space.
OpenIn sheetsql1 tag match
Run an integrity check
Verify the database structure and content consistency.
OpenIn sheetsql1 tag match