how to import .sql into sqlite3

Question

I have .sql files which has following contents :

#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 these are created automatically? Thanks.

Answer 1

Have you tried sqlite3 database.sqlite3 < db.sql? You'll need to make sure that your files contain valid SQL for sqlite.

Answer 2

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);