"...alimentation interruption..." --- Power interruption -- fascinating how
languages work!

Yohann,

Sqlite tends to be pretty good in the face of power interruptions on most
OS's, sorry you are having trouble.

I think you'll want to:
  1) copy your database in its current state (for safekeeping).
  2) See if the "vacuum" command will run, and if all tables remain
afterwards.
               http://www.sqlite.org/lang_vacuum.html
  3) Try a ".dump" command on the entire database.
  4) If the above .dump aborts on a particular table, try individual .dump
of
     all OTHER tables.
  5) Now gauge how much data, if any, is missing, 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 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

Reply via email to