Hi, This is what I was trying to do :
I double clicked on sqlite3.exe Then it opens a sqlite prompt Now I need to a do a data dump of a file which resides in c:\spool\jsm.db where jsm.db is the sqlite database. How can this be done? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Griggs, Donald Sent: 09 December 2008 15:49 To: General Discussion of SQLite Database Subject: Re: [sqlite] data dump in sqlite I'm not certain I understand your question, but here goes: Sqlite3.exe is a command-line interface, so you don't really "browse" at all. However, you can specify the path and name of a database on the command line when you invoke sqlite3, e.g. (In windows): Sqlite3 "c:\NiceDirectory_Without_spaces\MyDatabase.db" The quotes are usually optional, but not when your path contains spaces ALSO, you may want to see the ATTACH command in the documentation. Once inside sqlite3, the .databases command should produce SOME output, even if you haven't opened an existing database. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manisha De Silva Sent: Tuesday, December 09, 2008 10:36 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] data dump in sqlite 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 This message (and any associated files) ============= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users This message (and any associated files) is intended only for the use of the individual to which it is addressed and may contain information that is confidential, subject to copyright protection. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this message, and any associated files, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. We do not accept responsibility for any errors or omissions that are present in this message, or any attachment, that have arisen as a result of e-mail transmission. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. ePulse Limited Registered office: 4 Crown Place, London, EC2A 4BT Registered in England No 3534157 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
