Just pipe the text file to sqlite3
# sqlite3 DB.SQLITE <DB DEFINITION. TXT
--
Sent from myMail app for Android. Excuse my brevity
Saturday, 14 March 2015, 08:51am +00:00 from Mikael <mikael.trash at gmail.com>:
>I have a file DBDEFINITION.TXT that I want to use to initialize [execute
>on] the database DB.SQLITE.
>How do I do something like
>$ sqlite3 -exec DBDEFINITION.TXT DB.SQLITE
>$
>?
>All methods I tried end me up in the SQLite prompt, and that is what I
>don't want. Like, doing sqlite3 -init DBDEFINITION.TXT DB.SQLITE and having
>".quit" as last line in the definition file.
>Thanks.
>_______________________________________________
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
