Is it (corruption) related error code 10? (disk io) I would like to know, why sqlite throws disk io error while inserting records...
On Thu, Dec 6, 2012 at 10:43 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 6 Dec 2012, at 5:04pm, Durga D <durga.d...@gmail.com> wrote: > > > i mean in second case. some records corrupted but not all. How to recover > > this? > > There's no fixed answer. It depends on which parts of the file are > corrupt, and what they had written to them. If you used the shell tool on > the database and dumped all the data using .dump you might get perfectly > usable file with all data you could just .read back in. On the other hand > the corruption might be in a pointer that caused the .dump routine to > crash, or go around in circles listing the same rows again and again. > > 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