Just another 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: Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: