I am writing a shell script to scp a project and part of it involves transferring some important tables in my database.
I have the following stored in the file
$ sqlite3 SQLTableTransfer
The parameter you give to the
sqlite3 program is the database file name.
To execute commands from a file, you must redirect the input to that file:
$ sqlite3 mydatabase.db < SQLTableTransfer
or tell it to read from that file:
$ sqlite3 mydatabase.db ".read SQLTableTransfer"