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.
