Tuesday, June 02, 2009

how to read the sms text messages backed up by iTunes from your iPhone 3G 3.0

at the Terminal:

$ sqlite3 Library/Application\ Support/MobileSync/Backup/$most_recent_entry/3d0d7e5fb2ce288813306e4d4636395e047a3d28.mddata
(replace $most_recent_entry with the name of the most recent directory)

sqlite> .schema message
(this will show the structure for the message table)

Then you can ask things like:
sqlite> select * from message where text like '%days%';

No comments: