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

Reply via email to