"...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: [email protected]
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
