Yesterday I accidentally deleted an SMS banking notification thread on my Android device.
A classic case: I didn't backup the messages for very long time.
After flashing the recovery and rooting the device I pulled the
mmssms.db SQLite3 database along with its
-wal files. Inspecting the contents of the database didn't give a chance to recover the messages: neither the
threads nor the
sms tables provide a "soft deletion" column, so the messages are deleted from the database physically.
However, grepping for the banking notification text in the
-wal file resulted in very many occurrences of the notification plain text so I'm sure: the data is locked there somehow. Opening the database using
sqlite3 merely deletes the
I'm wondering: is it possible to extract the data out of the
-wal file or rollback the deletion (at least for both
sms tables) merging the deleted contents back to the