Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Richard Hipp
On Wed, Jan 4, 2012 at 6:06 PM, Tilsley, Jerry M. wrote: > Anyway to make the new version the default for the sqlite command when > executed from various directories? > Statically link SQLite with your application. Then you always know which version it is using. I beg people to do this. But fe

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Tilsley, Jerry M.
Anyway to make the new version the default for the sqlite command when executed from various directories? Sent from my Verizon Wireless Device Simon Slavin wrote: On 4 Jan 2012, at 9:43pm, Tilsley, Jerry M. wrote: > Ok, I'm ending up with two versions of SQLite installed on my system because

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Stephan Beal
Try: # export LD_LIBRARY_PATH=/path/to/your/libs:$LD_LIBRARY_PATH # your commands here... (sorry, i'm on a mobile phone lying in bed or i'd be more specific/detailed!) - stephan beal http://wanderinghorse.net/home/stephan/ On Jan 5, 2012 12:07 AM, "Tilsley, Jerry M." wrote: > Anyway to m

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Simon Slavin
On 4 Jan 2012, at 9:43pm, Tilsley, Jerry M. wrote: > Ok, I'm ending up with two versions of SQLite installed on my system because > one was install with RPM and the latest is a tarball. How do I get the > tarball to overwrite the pre-existing version? I recommend that you not worry about this

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Tilsley, Jerry M.
-6563 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Stephan Beal Sent: Wednesday, January 04, 2012 10:45 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Performing Backup via TCL, receiving error On Wed,

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Stephan Beal
On Wed, Jan 4, 2012 at 4:40 PM, Simon Slavin wrote: > In that case, the problem is not caused by a corrupt database file. It > now seems more likely that you have discovered an obscure bug, or are using > a version of SQLite not compiled for your platform, or have some other > compatibility prob

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Simon Slavin
On 4 Jan 2012, at 3:37pm, Tilsley, Jerry M. wrote: > I done as you requested and built a new file. The new TEA extension still > fails with SEGMENTATION FAULT when trying to perform backup. In that case, the problem is not caused by a corrupt database file. It now seems more likely that you

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Tilsley, Jerry M.
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, January 04, 2012 10:33 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Performing Backup via TCL, receiving error On 4 Jan 2012, at 1:53pm, Tilsley, Jerry M. wrote: > How ca

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Simon Slavin
On 4 Jan 2012, at 1:53pm, Tilsley, Jerry M. wrote: > How can I "upgrade" the existing database files to the new version? Use the sqlite3 shell tool to open the database. You can download a precompiled version here: Open the database OS prompt> sqlite3

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Tilsley, Jerry M.
Behalf Of Tilsley, Jerry M. Sent: Wednesday, January 04, 2012 10:24 AM To: 'sqlite-users@sqlite.org' Subject: Re: [sqlite] Performing Backup via TCL, receiving error Attached is one of the databases I am having trouble with. If I use the new version of SQLite to back up the file it w

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Tilsley, Jerry M.
- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy Sent: Wednesday, January 04, 2012 10:19 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Performing Backup via TCL, receiving error On 01/04/2012 08:53 PM, Tilsley, Jerry M. wrote: > I

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Dan Kennedy
On 01/04/2012 08:53 PM, Tilsley, Jerry M. wrote: I did manage to get the new version installed on the system, but the issue persists. But I did create a new database file under the 3.7.9 version and can back this up with no problem, but the database files under the 3.6.4 version crash. How ca

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Tilsley, Jerry M.
On Behalf Of Richard Hipp Sent: Wednesday, January 04, 2012 8:27 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Performing Backup via TCL, receiving error On Wed, Jan 4, 2012 at 8:23 AM, Tilsley, Jerry M. wrote: > I use the tcl commands: > > Sqlite3 db h.db > Db

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Richard Hipp
-Original Message- > From: sqlite-users-boun...@sqlite.org [mailto: > sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy > Sent: Wednesday, January 04, 2012 12:03 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Performing Backup via TCL, receiving error > > On 01/04/201

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-04 Thread Tilsley, Jerry M.
: [sqlite] Performing Backup via TCL, receiving error On 01/04/2012 06:55 AM, Tilsley, Jerry M. wrote: > All, > > I am attempting to generate a backup script written in TCL that will backup > all the databases in a given directory. These databases were all created > with SQLite version

Re: [sqlite] Performing Backup via TCL, receiving error

2012-01-03 Thread Dan Kennedy
On 01/04/2012 06:55 AM, Tilsley, Jerry M. wrote: All, I am attempting to generate a backup script written in TCL that will backup all the databases in a given directory. These databases were all created with SQLite version 3.6.4. I have the tea package for version 3.7.9 which is what I am u

[sqlite] Performing Backup via TCL, receiving error

2012-01-03 Thread Tilsley, Jerry M.
All, I am attempting to generate a backup script written in TCL that will backup all the databases in a given directory. These databases were all created with SQLite version 3.6.4. I have the tea package for version 3.7.9 which is what I am using to execute the backup command. When the scrip