On 17 Dec 2013, at 7:53am, Priyam Chokhani <priyam.chokh...@capillarytech.com> 
wrote:

> Integrity check gives the following result -
> 
> <z:row integrity_check="**** in database main *** On tree page 18 cell 8:

Once you have a database that fails the integrity check, it's pointless trying 
to do anything with it.  You will get unpredictable errors and data loss of all 
kinds.  Violating constraints would be a good example.

If you do not have a backup of your database file from before the corruption, 
try using the SQLite shell tool to '.dump' the contents as SQL commands, then 
to create another database with that data in.  The new database won't have the 
integrity problems the old one did.

You can find the shell tool here:

<http://www.sqlite.org/download.html>

instructions here:

<http://www.sqlite.org/sqlite.html>

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to