Save messages from iPhone to CVS file on Mac OS X

QuanTriMang.com - Normally, we will use iTunes to backup all messages from iPhone. If you have jailbroken your iPhone, you will find that there are other ways to save sms as CVS files, and use this file on other devices. In essence, all SMS or text messages in iPhone are managed from a database. When performing the jailbreak process on the iPhone, you affected this database and can export all the information inside, this CVS file cannot be opened with Microsoft Excel or similar programs. In the following article, Administrator will guide you how to backup and restore all sms to CVS file on Mac OS X system.

First, you will need the following support tools: iPhone Explorer and SQLite Database Browser. After that, we will move on to the next step - backup the sms database. Connect iPhone to computer via cable, start iPhone Explorer and point to the following link: / private / var / mobile / Library / SMS , find SMS.db file and copy to computer using Mac:

Save messages from iPhone to CVS file on Mac OS X Picture 1

Next, start SQLite Database Browser, select File -> Open Database and open the SMS.db file saved from the previous step:

Save messages from iPhone to CVS file on Mac OS X Picture 2

And here is an example image after you open the * .db file with SQLite Database Browser:

Save messages from iPhone to CVS file on Mac OS X Picture 3

If you want to save to another format, use the File -> Export> Table as CSV File. The program will display the Choose table message to export as CSV text, select the Message table and click the Export button:

Save messages from iPhone to CVS file on Mac OS X Picture 4

Select the path to save the file and name it:

Save messages from iPhone to CVS file on Mac OS X Picture 5

After that, you can open this file with Numbers of iWork or Microsoft Excel to edit the data (if you want). Here you will see the data table with the corresponding rows and columns of information:

Save messages from iPhone to CVS file on Mac OS X Picture 6

Above is a basic and quite simple way to help users backup, restore sms data from iPhone to other devices, or can apply this method merely to store information, data Personal SMS of users. Good luck!