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
