On 12/9/08, Manisha De Silva <[EMAIL PROTECTED]> wrote: > I downloaded sqlite3.exe > > I typed in .databases and it doesn't show any database. Actually I have > sqlite db in C:\Program Files\Jabber Inc\Jabber XCP\var\spool and I want this > to dump the data to a text file. > > I typed in sqlite> .databases > > How can I browse to the specific folder name which contains the jsm.db sqlite > db file >
you really need to read the docs online first. Nevertheless, do the following (assuming 'spool' is the name of your database) c:\>sqlite3 C:\Program Files\Jabber Inc\Jabber XCP\var\spool SQLite version xxxxxx Enter ".help" for instructions sqlite> .output spool.sql sqlite> .dump <table name> Also, do enter ".help" on the sqlite command line to learn more. Hope this helps. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
