Open up a command prompt window. Then key sqlite3 <name of your db file> <RETURN>
That will ring up a command line accessto your Sqlite database. If you want a GUI interface there is a Firefox plugin which interfaces to Sqlite. Try that or one of the very many Sqlite GUI interfaces like Sqlitespy. Manisha De Silva wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
