Prerequisites

- A jailbroken iPhone;

 Sftp access to the iPhone (you must install the OpenSSH package in Cydia, have an sftp client on your desktop machine and connect the two on the same network) or a tool for transferring files as iphonefolders;

 A tool that can read files of databases Sqlite (included in Cygwin as the sqlite3.exe).

Method

Simply retrieve the files sms.db in the directory /private/var/mobile/Library/SMS/ on the iPhone that contains, in particular, the table message :

• ROWID unique identifier of the message
• address Phone number of the issuer knew SMS
• date date of the message (GMT) in seconds since 1 January 1970. You can easily convert this time to Unix in a readable format using the command date -u -R --date "1970-01-01 XXXXXXXX seconds" or XXXXXXXX is the number of seconds in question.
• text Message Content
• flags
• replace
• svc_center
• group_id
• association_id
• height
• UIFlags
• version
• subject
• country
• headers
• recipients
• read
• smsc_ref
• dr_date

It is possible to export the data file more easily usable by using the following commands (in bold what to type):

sqlite3 sms.db
SQLite version 3.6.21
Enter. "Help" for instructions
Enter SQL statements terminated With A ";"
sqlite>. html mode
sqlite>. messages.html output
sqlite> select * from message
sqlite>. quit

This produces a segment of html file in UTF-8. To open a Web browser (or Excel to edit easily), we must add the following code at the beginning of the file:

This produces a complete HTML file, easily editable ...