Thank you Roger, I will look this over and see what I can do. ~Kirk
Kirk Clemons Technical Support Analyst Chief Architect(r) 6500 N. Mineral Dr. Coeur d'Alene, Idaho 83815 Phone: (800)482-4433 (208)664-4204 Professional Software www.chiefarchitect.com Consumer Software www.HomeDesignerSoftware.com -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns Sent: Tuesday, August 03, 2010 5:56 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Repairing a Database. -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 08/02/2010 07:42 AM, Kirk Clemons wrote: > I have seen some information on repairing a corrupt database and recovering > at least some of the data. But I have not had any luck finding out how to do > it. You can use .dump in the shell. It does a 'select *' on each table outputting the rows (which will be in rowid order). If it gets SQLITE_CORRUPT then it repeats the select, but in reverse rowid order so in theory you'll get the rows before and after the corruption. In general you cannot repair or recover a corrupt database because to do so would mean that information has to be stored redundantly - ie you could use a duplicate to reconstruct the original. The one exception is that indices can be dropped and recreated since they are redundant. The file format information will be most helpful. The two documents describe the same thing but with different styles. http://www.sqlite.org/fileformat.html http://www.sqlite.org/fileformat2.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkxYup8ACgkQmOOfHg372QTYuwCg2GpSzG5qzltWQliyplKyPU2r sTAAnROPV+qQcmhouUl9/z6RLDMnTMjm =fvzY -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users