Select Page

How to export/backup all your SMS from the Apple iPhone to the disk

How to export/backup all your SMS from the Apple iPhone to the disk

iphone

You need of course a Jailbroken iPhone, normal and loyal user of Apple  you are not allowed to save your own SMS!!!

shh to your iphone, using WINSCP for example

iphone.export.sms.00

Use login root, default password is alpine (but you should have change it to something else for better security a long time ago)

Go to the directory  /private/var/mobile/Library/SMS

iphone.export.sms.01

and copy the file sms.db to your local disk

Download SQL lite browser at http://sqlitebrowser.sourceforge.net/

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to:

  • Create and compact database files
  • Create, define, modify and delete tables
  • Create, define and delete indexes
  • Browse, edit, add and delete records
  • Search records
  • Import and export records as text
  • Import and export tables from/to CSV files
  • Import and export databases from/to SQL dump files
  • Issue SQL queries and inspect the results
  • Examine a log of all SQL commands issued by the application

open the file sms.db  in Sql Lite Browser

iphone.export.sms.02 

Click on the Tab “Browse Data” and select the Table “Message”, you can see your SMS!

Now under the menu File – Export – Export as CSV

iphone.export.sms.03

You’re done!

iphone.export.sms.04

Attention: even if the file format (CSV) can be read in any text editor /Open Office/Office Excel, the data are not presented in an user friendly manner!

#@$!& APPLE: This is My iPhone and these are MY DATA!

About The Author

I worked with various Insurances companies across Switzerland on online applications handling billion premium volumes. I love to continuously spark my creativity in many different and challenging open-source projects fueled by my great passion for innovation and blockchain technology.In my technical role as a senior software engineer and Blockchain consultant, I help to define and implement innovative solutions in the scope of both blockchain and traditional products, solutions, and services. I can support the full spectrum of software development activities, starting from analyzing ideas and business cases and up to the production deployment of the solutions.I'm the Founder and CEO of Disruptr GmbH.

Categories