I'm trying to import a .sql file into a db on Windows. I'm doing a
migration. I was able to create the .sql file from the old sqlite3 db
with the dump command. But I cannot figure out the syntax/format of the
import command for Windows. The examples on the sqlite3 site are for
*nix, and seem to use the 'zcat' command instead of import. I searched
the archives for this and the only response said to look at the docs for
the 'copy' command, but I couldn't find any documentation for the copy
command. Or the import command, for that matter. The .help for .import
only says ".import FILE TABLE" but apparently that's not complete
either.
Does anyone have an example of doing an import from a .sql file into an
existing sqlite3 db? I've tried:
sqlite3 .import <pathToSQLFile> <pathToDB>
sqlite3 .import <pathToSQLFile> | <pathToDB>
sqlite3 <pathToSQLFile> <pathToDB> .import
sqlite3 <pathToSQLFile> | <pathToDB> .import
and various other permutations. It usually give me an error saying
'syntax error at' the start of my <pathToSQLFile>
Thanks
PS - sorry for the silly disclaimer
--------------------------------------------------------------------------
This e-mail message is intended only for the personal use of the
recipient(s) named above. If you are not an intended recipient,
you may not review, copy or distribute this message. If you have
received this communication in error, please notify First DataBank
Support ([EMAIL PROTECTED]) immediately by e-mail
and delete the original message.
--------------------------------------------------------------------------