SQLite Save Temporary Database to A File

If you start shell without supplying a filename, you may save temporary database at any time using:

sqlite> .backup MAIN "folder\your_file.extension"

Or you can ATTACH an existing database an use SQL methods:

sqlite> ATTACH DATABASE "path\stored.db" AS other;
sqlite> INSERT OR REPLACE INTO other.table1 SELECT * FROM this_table1;
sqlite> DETACH other;