Hi, everyone

Is it possible to restore deleted rows or dropped tables provided the WAL and 
shm files are still intact and contain the data you want to restore?

Example scenario where vast swathes of content have vanished from mmssms.db 
thanks to an unintentional mass-DELETE FROM through the naughty Android SMS app:

ls -al /data/data/com.android.providers.telephony/databases/mm*
-rw-rw----    1 root     root         60416 Jul 17 20:16 mmssms.db`
-rw-rw----    1 radio    radio        32768 Jul 17 16:18 mmssms.db-shm
-rw-rw----    1 radio    radio       628832 Jun 30 19:23 mmssms.db-wal

TIA,

Mandy
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to