Skip to main content

Overview

The import command will upload a SQLite database to a LiteFS cluster. If the named database doesn’t exist, it will be created. If it does exist, it will be replaced. This command is safe to use on a live database. The database file is not validated for integrity by LiteFS. You can perform an integrity check first by running “PRAGMA integrity_check” from the SQLite CLI.

Usage

Arguments

You’ll need to specify a name for the database using the -name flag. This is the filename that your application will use to access the database.
If you are importing a database to a remote LiteFS node, you’ll need to specify the base API URL for that node. This defaults to the local LiteFS node.

Examples

Importing to a local instance

Import a database from /path/to/db to a database called my.db on a local LiteFS node:

Importing to a remote instance

Import a database from /path/to/db to a database called my.db on a remote LiteFS node with a hostname of myotherhost: