How to import .sql files in SQLite 3?

Question

I have .sql files that 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 to import this file into SQLite so that they are automatically created?

Answer 1

From the sqlite prompt:

 sqlite> .read db.sql 

Or:

 cat db.sql | sqlite3 database.db 

Also, your SQL is invalid - you need to ; at 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

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

Answer 3

You can also do:

 sqlite3 database.db -init dump.sql 

Answer 4

Alternatively, you can do this from the Windows command line command 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.