Yes it has create queries and insert statements....
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