On 1/27/09, venkat karri <venkat9...@gmail.com> wrote: > Yes it has create queries and insert statements....
in which case, it is a SQL dump. Read up the help on the .read command or the .import command in the command line sqlite3 program. > > > On 1/27/09, Simon <turne...@gmail.com> wrote: > > > > You may want to open the file in a basic text editor to see if it's a > > SQL dump. The dump will usually have the queries to create the tables > > and insert data into them. > > > > Simon > > > > On Tue, Jan 27, 2009 at 11:57 AM, venkat karri <venkat9...@gmail.com> > > wrote: > > > Hi Kishor, > > > > > > Actually iam working on defect tracking migration from trac to > > > qualitycenter, the trac developers have given me this .bak file, the > > person > > > who has taken this bak file is no longer with the company, so they asked > > me > > > to restore the .bak file and see the data, I dont know how its been > > created, > > > > > > > > > when u said you can directly open the sqlite file, how to do that? > > > > > > > > > On 1/27/09, P Kishor <punk.k...@gmail.com> wrote: > > >> > > >> On 1/27/09, venkat karri <venkat9...@gmail.com> wrote: > > >> > Hi > > >> > > > >> > Iam new to sqlite, I have a database backup copy with extension > > >> > trac.db.1.bak. Now iam trying to setup sqlite 3.6.10 on my local > > machine > > >> and > > >> > need to import this bak file to my local database and has to view the > > >> data > > >> > in the table. > > >> > > > >> > can any one help me how to restore the database into my local > > machine, > > >> Is > > >> > there a client interface tool like toad to connect to server and view > > >> the > > >> > data? > > >> > > > >> > > >> > > >> How did you make "trac.db.1.bak"? If it is just a sqlite file, you can > > >> open it directly with sqlite. If it is a sql dump, you can .read that > > >> into sqlite. If someone created and gave you "trac.db.1.bak" you need > > >> to find out from that person how it was created. > > >> _______________________________________________ > > >> 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 > > > > > > > > > > > -- > > When Earth was the only inhabited planet in the Galaxy, it was a > > primitive place, militarily speaking. The only weapon they had ever > > invented worth mentioning was a crude and inefficient nuclear-reaction > > bomb for which they had not even developed the logical defense. - > > Asimov > > _______________________________________________ > > 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 > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users