How to Import .SQL Files into SQLite 3

How do I import .sql files into SQLite 3?

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

How to import a .sql file to sqlite via nodejs exec

Pipe | is a shell tool for chaining commands. In Node you need to separate your commands and redirect first output to next input.

var fs = require("fs")
, spawn = require("child_process").spawn
, child = spawn("sqlite3", ["mydb.db"])

fs.createReadStream("./db.sql").pipe(child.stdin)

Related Topics