Thanks a lot Simon! We'll try it.
(BTW I also got an email from alexa, but looking in the sqlite mailing list I can see that I'm not the only one) On 10/19/2015 06:20 PM, Simon Slavin wrote: > On 19 Oct 2015, at 5:13pm, gunnar <gharms at hiqinvest.nl> wrote: > >> We run sqlite with PRAGMA synchronous=OFF. >> >> Now we suffered from a 'hard reboot' because a sysadmin unplugged the power >> cable :( >> >> Is it possible to repair > First take a copy of the database file and any other file from the same > directory with a similar name. This is just in case you decide to use heroic > (i.e. expensive) means to rescue the database later. > > Open the proper (not the copy) database using the SQLite Shell Tool > downloadable from the SQLite site. Use the '.dump' command to dump the > database as a text file of SQL commands. > > Read through that file and see if it looks like it has captured all your data > in it. If it has ... > > Create a new blank database using the SQLite Shell Tool. > Use the '.read' command to execute the commands in the text file. > Use various commands in the SQLite shell tool to explore the resulting > database and see if it looks like it's worth using. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
