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