data

Data (/ˈdeɪtə/ DAY-tə, /ˈdætə/ DA-tə, or /ˈdɑːtə/ DAH-tə) is a set of values of qualitative or quantitative variables; restated, pieces of data are individual pieces of information. read more at WikiPedia

  • 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!