Thanks Simon! We also store our critical data synchronously in flat (csv) files before sending it in the sqlite database. When the hard reboot occured only one of these was corrupted and only the last line. We can always refill sqlite from these files, we use sqlite to allow us to easily offer a bit more sophisticated interface.
On 10/22/2015 03:29 PM, Simon Slavin wrote: > On 22 Oct 2015, at 11:16am, gunnar <gharms at hiqinvest.nl> wrote: > >> It's good to know there are so many possibilities to repair when it is >> really needed! > But it's worth noting that these are only possibilities. There is no > guarentee of repair. And trying out one possibility can corrupt your > database further so that the other won't work. So always take a copy. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
