Re: [sqlite] help : sqlite database restore

[venkat karri]

Thanks a lot Donald, These links really helps me a lot...

On 1/27/09, Griggs, Donald  wrote:
>
>
>
> On 1/27/09, Griggs, Donald  wrote:
> >
> > Venkat,
> >
> > If you have a ".db" file it almost certainly *is* an sqlite database.
> > A great attribute of sqlite databases is that they are contained in a
> > single file.
> >
> > If you're looking for a GUI frontend, they are legion, including good
> > free ones such as sqlite3explorer and a plug-in sqliteManager for
> > firefox webbrowser.
> >   See http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
> >
> > Donald
> >
> =
>
> Hi Donald,
>
> Thanks for the link thats helpful, How do i access the .db file and read
> the data...
> =
>
> Venkat,
>
> There may be a bit of a language barrier here.  Each of the GUI sqlite
> utilities can be used to access and read the data in an sqlite database.
> Each has it's own instructions.  Often, one chooses to "open" the
> database file from within the GUI.  One then supplies the desired SQL
> instructions and asks that they be "executed" by some means.  There are
> even ODBC wrappers available so that you may even be able to use some
> tool with which you are already familiar.
>
> All of the data, of course, is also available by using the Command Line
> Utility provided as part of the official release.  Have you downloaded
> the utility and/or a GUI front-end?  Have you had trouble with the
> directions provided by them?
>
> If you're comfortable with the command line utility, for instance, have
> you had trouble after reading page,
> http://www.sqlite.org/quickstart.html ?
>
> If so, you may need to elaborate on "access" and "read the data" since
> I'm not as sure as I was earlier that I understand the difficulty you're
> having.
>
> ___
> 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

Re: [sqlite] help : sqlite database restore

[Griggs, Donald]

Venkat,

Sorry.  I really intended to quote page:
 http://www.sqlite.org/sqlite.html 
Though
 http://www.sqlite.org/quickstart.html
May be helpful as well.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] help : sqlite database restore

[Griggs, Donald]

On 1/27/09, Griggs, Donald  wrote:
>
> Venkat,
>
> If you have a ".db" file it almost certainly *is* an sqlite database.
> A great attribute of sqlite databases is that they are contained in a 
> single file.
>
> If you're looking for a GUI frontend, they are legion, including good 
> free ones such as sqlite3explorer and a plug-in sqliteManager for 
> firefox webbrowser.
>   See http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
>
> Donald
>
=

Hi Donald,

Thanks for the link thats helpful, How do i access the .db file and read
the data...
=

Venkat,

There may be a bit of a language barrier here.  Each of the GUI sqlite
utilities can be used to access and read the data in an sqlite database.
Each has it's own instructions.  Often, one chooses to "open" the
database file from within the GUI.  One then supplies the desired SQL
instructions and asks that they be "executed" by some means.  There are
even ODBC wrappers available so that you may even be able to use some
tool with which you are already familiar.

All of the data, of course, is also available by using the Command Line
Utility provided as part of the official release.  Have you downloaded
the utility and/or a GUI front-end?  Have you had trouble with the
directions provided by them?

If you're comfortable with the command line utility, for instance, have
you had trouble after reading page,
http://www.sqlite.org/quickstart.html ?

If so, you may need to elaborate on "access" and "read the data" since
I'm not as sure as I was earlier that I understand the difficulty you're
having.   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] help : sqlite database restore

[venkat karri]

Hi Donald,

Thanks for the link thats helpful, How do i access the .db file and read the
data...


On 1/27/09, Griggs, Donald <donald.gri...@allscripts.com> wrote:
>
> Venkat,
>
> If you have a ".db" file it almost certainly *is* an sqlite database.
> A great attribute of sqlite databases is that they are contained in a
> single file.
>
> If you're looking for a GUI frontend, they are legion, including good
> free ones such as sqlite3explorer and a plug-in sqliteManager for
> firefox webbrowser.
>   See http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
>
> Donald
>
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of venkat karri
> Sent: Tuesday, January 27, 2009 3:25 PM
> To: punk...@eidesis.org; General Discussion of SQLite Database
> Subject: Re: [sqlite] help : sqlite database restore
>
> 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.
>
> ___
> 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

Re: [sqlite] help : sqlite database restore

[Griggs, Donald]

Venkat,

If you have a ".db" file it almost certainly *is* an sqlite database.
A great attribute of sqlite databases is that they are contained in a
single file.

If you're looking for a GUI frontend, they are legion, including good
free ones such as sqlite3explorer and a plug-in sqliteManager for
firefox webbrowser.
   See http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

Donald
 

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of venkat karri
Sent: Tuesday, January 27, 2009 3:25 PM
To: punk...@eidesis.org; General Discussion of SQLite Database
Subject: Re: [sqlite] help : sqlite database restore

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.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] help : sqlite database restore

[venkat karri]

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  wrote:
>
> On 1/27/09, venkat karri  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  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 
> >  > 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  wrote:
> >  > >>
> >  > >> On 1/27/09, venkat karri  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

Re: [sqlite] help : sqlite database restore

[P Kishor]

On 1/27/09, venkat karri  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  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 
>  > 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  wrote:
>  > >>
>  > >> On 1/27/09, venkat karri  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

Re: [sqlite] help : sqlite database restore

[venkat karri]

Yes it has create queries and insert statements

On 1/27/09, Simon  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 
> 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  wrote:
> >>
> >> On 1/27/09, venkat karri  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

Re: [sqlite] help : sqlite database restore

[Simon]

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  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  wrote:
>>
>> On 1/27/09, venkat karri  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

Re: [sqlite] help : sqlite database restore

[venkat karri]

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  wrote:
>
> On 1/27/09, venkat karri  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

Re: [sqlite] help : sqlite database restore

[P Kishor]

On 1/27/09, venkat karri  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