Can you try doing table copies using select with offset and limit? See where limit crashes the system and then offset past it perhaps?
Just a guess on my part as one possibility. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Durga D [durga.d...@gmail.com] Sent: Thursday, December 06, 2012 11:04 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] disk image malformed i mean in second case. some records corrupted but not all. How to recover this? On Thu, Dec 6, 2012 at 10:27 PM, Durga D <durga.d...@gmail.com> wrote: > Is there anyway to recover? > > > On Thu, Dec 6, 2012 at 10:23 PM, Richard Hipp <d...@sqlite.org> wrote: > >> On Thu, Dec 6, 2012 at 11:52 AM, Durga D <durga.d...@gmail.com> wrote: >> >> > Hi, >> > >> > Is it possible to corrupt a single table among 10 tables in a >> database? >> > >> > Is it possible to corrupt some records among millions of records in a >> > table? >> > >> >> Yes. Yes. >> >> >> >> > >> > Best Regards, >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> >> >> >> -- >> D. Richard Hipp >> d...@sqlite.org >> _______________________________________________ >> 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users