On 12/9/08, Manisha De Silva <[EMAIL PROTECTED]> wrote: > I tried this line of code to do a data dump but it doesn't seem to work > > > sqlite> .dump sqlite3 c:\spool\jsm.db gzip -c > jsm.dump.gz > BEGIN TRANSACTION; > COMMIT; > sqlite> > >
You seriously need to read the docs and the help first before asking such basic questions that have all been documented. Nevertheless, here are step-by-step instructions c:\> sqlite3 c:\spool\jsm.db sqlite> .output jsm.sql sqlite> .dump sqlite> .quit c:\> You should be able to located jsm.sql on your c:\> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users