Ok, I'll try those steps and I keep you informed.
-----Message d'origine----- De : Griggs, Donald [mailto:[EMAIL PROTECTED] Envoyé : mardi 8 août 2006 14:54 À : sqlite-users@sqlite.org Objet : RE: [sqlite] Recovery tool ? "...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
