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

Reply via email to