This morning I had a meeting with the team and found that we also have a db file, could you please send me the complete syntax to import or restore this .db file in sqlite.
On 1/27/09, P Kishor <punk.k...@gmail.com> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
