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?
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);
.read <file>?Use sqlite3 database.sqlite3 < db.sql. You'll need to make sure that your files contain valid SQL for SQLite.
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.
You can also do:
sqlite3 database.db -init dump.sql
sqlite3 client running in the interactive prompt.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
