Name
.restore — Perform a low-level copy of a database file to a database
Common Usage
.restore [database_name]filename
Description
The .restore command performs a low-level copy of a
database file into an open or attached database. If the database
name is not provided, the main database will be populated. This
command is frequently used to populate an active in-memory
database from a database file. This command is safe to run
against an active source database (although it may not
succeed).
This is the opposite of the .backup command.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access