onlydarksets

Just another WordPress.com weblog

Viewing SMS from a jailbroken iPhone

Posted by onlydarksets on October 1, 2008

  1. Download sqlite.
  2. SFTP into the iPhone.
  3. Download sms.db into the same folder.
  4. Open a command window, navigate to the directory where sqlite and sms.db are, and enter the following:
c:\sqlite sms.db
sqlite> .output messages.txt
sqlite> select * from message;
sqlite> .output stdout
sqlite> .quit

That’s it – now you can import the messages.txt file into Excel and view the messages.

One Response to “Viewing SMS from a jailbroken iPhone”

  1. […] Export it using sqlite […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: