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


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


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


and copy the file sms.db to your local disk

Download SQL lite browser at

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


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


You’re done!


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!

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments


Would love your thoughts, please comment.x