On Mon, 27 Jul 2009 20:39:34 -0700 (PDT), Mutiullah Qureshi
<mutiulla...@yahoo.com> wrote:

>Hello friends.
>I have downloaded sqlite3-3.6.16.bin.gz and extracted sqlite3-3.6.16.bin in 
>fedora 9. Now I want to dump cookies.sqlite from mozila firefox cache to 
>cookies.tmp. I have tried:
>
>sqlite> .dump cookies.sqlite cookies.tmp

You are already in sqlite there. It is unclear which
database you specified on the command line.


It's a one liner (from the shell prompt):

sqlite3 /path/to/cookies.sqlite .dump >cookies.tmp

Note: the optional parameter of .dump is not a database, but
one or more table names. Without parameter .dump dumps all
tables.

For more help use
(from the shell prompt)
sqlite3 -help 
        for command line options

(from the sqlite prompt)
sqlite> .h
        for the command line tool commands.

>BEGIN TRANSACTION;
>COMMIT;
>sqlite> 
>
>But this does not create any cookies.tmp. 
>I am a newbie on this environment, 
>just switched from Windows systems. PLease guide me.
-- 
  (  Kees Nuyt
  )
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to