Sms

http://code.google.com/p/iphone-sms-archive/wiki/Instructions

Prerequisites

You must have an SFTP server installed and working.

These instructions are tailored for Mac OS X General Idea

We will SFTP into the phone, grab the sms.db file, use SQLITE3 to dump the contents of the database, and run a simple C program to convert the dump file to an HTML page. Instructions

sftp root@<iPhone IP address>
get /private/var/root/Library/SMS/sms.db sms.db
quit

sqlite3 sms.db
.output out.txt
SELECT * from message;
.quit

gcc main2.c
./a.out out.txt out.html

Media:main2.c