RE: [sqlite] Recovery tool ?

2006-08-08 Thread zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
> What OS are you using? Linux 2.6.15-23-server #1 SMP Tue May 23 15:10:35 UTC 2006 i686 GNU/Linux It's an ubuntu 6.06 server distribution. > What kind of mass storage? (Disk or flash?) It's just the disk of the computer on which I installed sqlite, I don't use any mass storage device. The

RE: [sqlite] Recovery tool ?

2006-08-08 Thread zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
I have identified the only table which is corrupted. > 2) See if the "vacuum" command will run, and if all tables remain afterwards. > http://www.sqlite.org/lang_vacuum.html It does not work, I have the same message: SQL error: database disk image is malformed > 3) Try a ".dump"

RE: [sqlite] Recovery tool ?

2006-08-08 Thread zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
ing, and plan your remediation. -----Original Message- From: zze-ContentLab MARTINEAU Y ext RD-SIRP-REN [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 08, 2006 4:48 AM To: sqlite-users@sqlite.org Subject: [sqlite] Recovery tool ? Hello, I had an alimentation interruption on my sqlite database runn

RE: [sqlite] Recovery tool ?

2006-08-08 Thread zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
: mardi 8 août 2006 13:38 À : sqlite-users@sqlite.org Objet : Re: [sqlite] Recovery tool ? "zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL PROTECTED]> wrote: > Hello, > > I had an alimentation interruption on my sqlite database running on > linux. And now the dat

[sqlite] Recovery tool ?

2006-08-08 Thread zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
Hello, I had an alimentation interruption on my sqlite database running on linux. And now the data file seems to be corrupted. Is there any tool to cleanup this file ? Or is it necessary to restart from a blank new data file ? Thank you, yohann

RE: [sqlite] Using Sqlite 3.2.1 on linux

2006-07-13 Thread zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
lto:[EMAIL PROTECTED] Envoyé : jeudi 13 juillet 2006 13:48 À : sqlite-users@sqlite.org Objet : Re: [sqlite] Using Sqlite 3.2.1 on linux "zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL PROTECTED]> wrote: > Here is what I have been told regarding the application: > &

RE: [sqlite] Using Sqlite 3.2.1 on linux

2006-07-13 Thread zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
50 À : sqlite-users@sqlite.org Objet : Re: [sqlite] Using Sqlite 3.2.1 on linux "zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL PROTECTED]> wrote: > > I have to use sqlite 3.2.1 with an application (newer version of > thread usage is not supported in the code). Huh?

[sqlite] Using Sqlite 3.2.1 on linux

2006-07-13 Thread zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
Hello, I have to use sqlite 3.2.1 with an application (newer version of thread usage is not supported in the code). I would like to use it on an ubuntu 6.06 server distribution of linux. I must enable threads usage, so I added the --enable-threads to the configure script. This script gives a