View/Export SMS from iPhone sms.db file
Here is how to recover SMS from iphone sms.db file, located at /private/var/mobile/Library/SMS/sms.db.
1. Rename sms.db to sms.sqlite
2. Open SMS database
Open Firefox and install the SQLite Manager add-on for Firefox, restart firefox. Goto Web Developer->SQLite Manager. On SQLite Manager window click the open icon and selected sms.sqlite.
3. Open the Execute SQL tab and execute the following querry
SELECT rowid, address, date, text FROM message ORDER BY date
And wollah, there are all your sms.
4. Hit the Actions button and choose Save Result(CSV) to file
there you have all your sms in a CSV.