Spiga

How to Backup iPhone Text Messages on Windows

How to Backup iPhone Text Messages on Windows

If you want to backup iPhone text message on Windows, here is a free method to do that, first we access iPhone SMS database file then view or export iPhone text message from it SMS.db file using SQLite DB browser and then backup iPhone text messages as .csv file / Excel spreadsheet.
Backup iPhone Text messages or Export iPhone SMS

Step-1

First you need to access iPhone files, to browse the iPhone files and folders you have to SSH into iPhone. If you didn’t SSH into your iPhone yet, Follow this guide: how to SSH into iPhone and then come back here on the next step-2.

Step-2

When you successfully connected to your iPhone using WinSCP on Windows,navigate to the following folder in WinSCP : /private/var/mobile/Library/SMS/ this folder is sms.db location which contains all your iPhone Text Messages in SQLite Database format.
navigate-to-sms-db-folder

Step-3

Just copy and transfer this “sms.db” file on your computer desktop.
copy-sms-db
SMS.db on your computer desktop.
sms-db-file

Step-4

Download SQLite Database Browser and extract it.
extract-sqlite-database-browser
Run “SQLite Database Browser” .EXE file from extracted folder to run SQLite DB Browser.
run-sqlite

Step-5

Click “Open Database” icon to open the saved “SMS.db” file.
open-sms-db-file
Choose “SMS.db” file that we have saved in step-3.
choose-db-file

Step-6

To view your iPhone SMS, click on “Browse Data” tab and select “message” table from table drop down menu as shown below.
browse-data
Here you can view all iPhone text messages with Address, Date, Text and some other information.
messages-table

Step-7

Export iPhone text messages, click on “File” menu, select “Export” and select “Table as CSV file” option.
export-all-text-messages

Step-8

Select “message” database table from “Table name” drop down menu and hit Export button.
export-sms

Step-9

Type file name with .csv extension and hit “Save” button.
save-as-csv
After success this will prompt with Export completed message.
export-text-messages-completed
Here you have your all iPhone text message in CSV format, in other words iPhone SMS in Excel Spreadsheet. You can view iPhone text messages CSV file in Microsoft Excel, Google Docs, or in other free CSV viewer.
exported-sms-file

0 nhận xét:

Your IP

IP
Blogger Widgets

Copy code, paste your site:

<p><span style="text-align:center; display: block;"><a href="http://win7-vista.blogspot.com/2011/02/get-ip-address-widget-for-your-blogger.html"><img src="http://www.wieistmeineip.de/ip-address/?size=468x60" border="0" width="468" height="60" alt="IP" /></a><br /><small><a href="http://win7-vista.blogspot.com/2011/02/get-ip-address-widget-for-your-blogger.html">Blogger Widgets</a></small></span></p>