Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > iPhone, iPod and iPad > iOS > Jailbreaks and iOS Hacks

Closed Thread
 
Thread Tools Search this Thread Display Modes
Old May 21, 2012, 04:16 PM   #1
tomthefear
macrumors newbie
 
Join Date: May 2012
extracting sms messages from iphone backup

I'm trying to extract sms messages from my iphone to an easy to read format on my mac (creating an "our textual relationship" thing for my gf)

I've had a look around a few places online, and it seems that this is possible.

Up to now I've used "Iphone backup extractor" to extract all of the ios files, have located sms.db, and I'm trying to use "sqlite database browser" to find the messages, but when I try to open the .db file it just looks blank.

Cant find a solution to this anywhere, and would really appreciate the help.

Thanks

Using ios 5.1.1 & osx 10.7.3
tomthefear is offline   0
Old May 21, 2012, 04:17 PM   #2
MastahRiz
macrumors 6502
 
Join Date: Aug 2010
This might be worthy a try:

http://forums.macrumors.com/showthread.php?t=1370853
MastahRiz is offline   0
Old May 21, 2012, 04:24 PM   #3
tomthefear
Thread Starter
macrumors newbie
 
Join Date: May 2012
Quote:
Originally Posted by MastahRiz View Post
Oh I forgot to mention that I'm not on a Jailbroken device
tomthefear is offline   0
Old May 21, 2012, 04:28 PM   #4
TSX
macrumors 68030
 
TSX's Avatar
 
Join Date: Oct 2008
Location: Texas
Just restore from that backup.
__________________
| Colt 6920 | P226 | P228 | G19 | S&W 422 |
TSX is offline   0
Old May 21, 2012, 04:30 PM   #5
MastahRiz
macrumors 6502
 
Join Date: Aug 2010
Ah that might make things a bit harder.

I think for non-jb devices the method you mentioned is the only way to go. Find the database in the backup and then extract with those sql tools.

Do you know someone with a jb idevice? You could copy your db to their phone and have them use the app for you. (Be sure to backup their db first!)

Or you could try jb-ing just to do the sms extraction and then restore your phone to get rid of the jb and then restore it from a backup to bring it back to how it is now.

I know those options all kind of suck, but not sure what else you can do. Hopefully others can chime in with something more helpful!

Good luck!
MastahRiz is offline   0
Old May 21, 2012, 04:32 PM   #6
tomthefear
Thread Starter
macrumors newbie
 
Join Date: May 2012
Quote:
Originally Posted by TSX View Post
Just restore from that backup.
I think you're misunderstanding me. I have all the messages on my phone, but i want to get them onto my mac into an easy to read format? like a text file.

(I know i could copy and paste the messages to an email, but I want about 6 months worth of messages, so this wouldn't really be an option)

Extracting from my backup seemed like the most straight forward route.
tomthefear is offline   0
Old May 21, 2012, 04:37 PM   #7
TSX
macrumors 68030
 
TSX's Avatar
 
Join Date: Oct 2008
Location: Texas
I think your SOL
__________________
| Colt 6920 | P226 | P228 | G19 | S&W 422 |
TSX is offline   0
Old May 21, 2012, 04:41 PM   #8
tomthefear
Thread Starter
macrumors newbie
 
Join Date: May 2012
Quote:
Originally Posted by TSX View Post
I think your SOL
great constructive help there
tomthefear is offline   0
Old May 21, 2012, 05:04 PM   #9
kingdLo
macrumors regular
 
Join Date: Mar 2009
You can use ibackup bot to view and extract the db to plain text format, db, or excel database.

I will say you won't see the SMS as normal, instead just broken down into plain text form. Some messages aren't in order, and in some the text isnt complete. Just something's I noticed earlier today looking at the SMS db
kingdLo is offline   0
Old May 21, 2012, 05:39 PM   #10
TSX
macrumors 68030
 
TSX's Avatar
 
Join Date: Oct 2008
Location: Texas
Quote:
Originally Posted by tomthefear View Post
great constructive help there
Its not help, its the truth.
__________________
| Colt 6920 | P226 | P228 | G19 | S&W 422 |
TSX is offline   0
Old May 22, 2012, 09:52 AM   #11
jpetticrew
macrumors 6502a
 
jpetticrew's Avatar
 
Join Date: May 2009
Location: Texas
PhoneView will extract your text conversations as a PDF and download all of the MMS files for you as well.
__________________
"Design is not just what it looks like and feels like. Design is how it works." - Steve Jobs
jpetticrew is offline   0
Old Jul 31, 2012, 08:51 PM   #12
andrewkotler
macrumors newbie
 
Join Date: Jul 2012
I think the decipher text message program is probably what you want. Looks like you can save or export your sms messages to your computer with the software. Also says they have a free trial on their site.
http://www.deciphertools.com
andrewkotler is offline   0
Old Oct 9, 2012, 01:19 PM   #13
Beti
macrumors newbie
 
Join Date: Aug 2010
Quote:
Originally Posted by andrewkotler View Post
I think the decipher text message program is probably what you want. Looks like you can save or export your sms messages to your computer with the software. Also says they have a free trial on their site.
http://www.deciphertools.com
I second Decipher Tools. I just used it to extract all my text messages from a backup. It'll default to saving them as an html page that looks like the iPhone text messages (little speech bubbles) but you can copy and paste that into a text document. Quick, easy and only $20.
Beti is offline   0
Old Oct 10, 2012, 09:36 PM   #14
Carlanga
macrumors 601
 
Carlanga's Avatar
 
Join Date: Nov 2009
Location: PR
"textual relationship"? is that text sex or something
__________________
☻ "A dream you dream alone is only a dream...
... A dream you dream together is reality." ☻
Carlanga is offline   0
Old Oct 19, 2012, 10:53 AM   #15
gwar28
macrumors newbie
 
Join Date: Mar 2012
http://blog.michaelboman.org/2011/04...om-iphone.html
gwar28 is offline   0
Old Nov 11, 2012, 03:46 PM   #16
Resist
macrumors 68030
 
Join Date: Jan 2008
I'm interested in doing this also, but noticed that some of the replies are for applications that only work on a PC. I believe the original poster asked about saving the texts on a Mac. And that's what I want as well.

In my case I want to remove some old texts from my iPhone 5, but save them to my Macbook Pro.
Resist is offline   0
Old Jul 21, 2013, 06:01 AM   #17
hxlover904
macrumors newbie
 
Join Date: Aug 2011
or iscavenge. it's free and works great. and works on a mac
hxlover904 is offline   1

Closed Thread
MacRumors Forums > iPhone, iPod and iPad > iOS > Jailbreaks and iOS Hacks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 01:35 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC