Storage:DetectingCorruption

Revision as of 18:02, 3 June 2008 by Dietrich (talk | contribs) (New page: * backup the database file you want to check * install Storage Explorer from [http://shawnwilsher.com/archives/119] * start the browser, and from the Tools menu, select Storage Explorer *...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
  • backup the database file you want to check
  • install Storage Explorer from [1]
  • start the browser, and from the Tools menu, select Storage Explorer
  • select the database filename from the left-hand column
  • in the text field on the right, do the following:
    • type "vacuum", click the Execute Statement button
    • clear the text field, type "pragma integrity_check", click the Execute Statement button

If the result is OK, then the database file is not corrupt (in a way sqlite can detect).