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
