How to import .sql files into SQLite3?

Question

I have .sql files which have the following content:

#cat db.sql
create table server(name varchar(50),ipaddress varchar(15),id init)
create table client(name varchar(50),ipaddress varchar(15),id init)

How do I import this file into SQLite so that these are created automatically?

Answer 1

From a sqlite prompt:

sqlite> .read db.sql

Or:

cat db.sql | sqlite3 database.db

Also, your SQL is invalid - you need ; on the end of your statements:

create table server(name varchar(50),ipaddress varchar(15),id init);
create table client(name varchar(50),ipaddress varchar(15),id init);

Answer 2

For example, you export apple.db to backup.sql with .dump or .schema as shown below. *backup.sql is created if it doesn't exist and .dump can export schema with data and .schema can export only schema and my answer explains how to export a database:

sqlite3 apple.db .dump > backup.sql

Or:

sqlite3 apple.db .schema > backup.sql

Now, you can import backup.sql into orange.db as shown below. *orange.db is created if it doesn't exist:

sqlite3 orange.db < backup.sql

Or:

sqlite3 orange.db
...
sqlite> .read backup.sql

Be careful, if you directly import apple.db into orange.db as shown below:

sqlite3 orange.db < apple.db

Or:

sqlite3 orange.db
...
sqlite> .read apple.db

Then, you get the error below:

Parse error near line 1: near "SQLite": syntax error

Answer 3

Alternatively, you can do this from a Windows commandline prompt/batch file:

sqlite3.exe DB.db ".read db.sql"

Where DB.db is the database file, and db.sql is the SQL file to run/import.

Answer 4

You can also do:

sqlite3 database.db -init dump.sql

Answer 5

Use sqlite3 database.sqlite3 < db.sql. You'll need to make sure that your files contain valid SQL for SQLite.