Recovering the data

To recover the data, for each .smatdb file (including -sec, but not -wal), identify which key is used for which site by running these commands:

  1. sqlite3 this.smatdb
  2. PRAGMA KEY = ‘first site name
  3. Select count (*) on smat_msgs
  4. .quit
    If the above steps work, then you can stop now. If not, then continue with these steps:
  5. sqlite3 this.smatdb
  6. PRAGMA KEY = ‘second site name
  7. Select count (*) on smat_msgs
  8. .quit