I do Integrity check every often.
On Sun, Dec 9, 2012 at 5:07 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 9 Dec 2012, at 12:44pm, dd <durga.d...@gmail.com> wrote: > > > Can I read the database when sqlite throws disk io or image malformed or > > other critical errors first time. I cannot simulate these issues on my > > machine. So, I need your suggestion. > > You should not continue to work with the database in your own application > on customer computers. > > I would recommend that you copy the database to your own computer and open > it with the sqlite3 shell tool: > > <http://www.sqlite.org/sqlite.html> > > you will find a copy on every Mac in '/usr/bin/sqlite3'. > > You can immediately run > > <http://www.sqlite.org/pragma.html#pragma_integrity_check> > > and find out whether the error means that the file itself is corrupt. If > the file fails the integrity check then the file is corrupt. if it > doesn't, it means that something went wrong (software or hardware) on your > customer's computer but that this didn't cause anything bad to be written > to the database file. > > Simon. > _______________________________________________ > 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
