Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

I need to migrate SMSs from an iPhone to an android, and I'd like to use solutions suggested here, but I can't find the SMS db file (reportedly named 3d0d7e5fb2ce288813306e4d4636395e047a3d28) in my unencrypted IOS6 backup.

What is the name / how can I identify the backup file?

Also relevant: http://apple.stackexchange.com/a/6904/6126

Tx!

share|improve this question
    
How many files are inside of the folder ~/Library/Application Support/MobileSync/Backup/<long_hex_string>/? –  SoFLy Feb 6 '13 at 8:30
    
thanks for your interest @SoFLy.. only 9013 :) –  memeLab Feb 6 '13 at 11:41
    
:O 9013 files? oof, sounds like a bit of digging would be required. You're not jailbroken, I'm assuming –  SoFLy Feb 7 '13 at 3:06
    
nope, not jailbroken.. I got a reply from Samsung Kies support: Kies eventually managed to import my SMSs from the iphone backup if anyone knows of what kind of header the correct file has have, I'd still be curious to track the db down... –  memeLab Feb 12 '13 at 6:41

1 Answer 1

Inside MobileSync/Backup// you should find this file "3d0d7e5fb2ce288813306e4d4636395e047a3d28"

Then open it with sqlite (eg sqlite firefox plugin or "sqlite database browser"), and execute this sql query :

    select message.rowid,
    case when message.date=0 then null else datetime(message.date,  'unixepoch', 'localtime', '+31 years') end as sent,
    case when message.date_delivered=0 then null else datetime(message.date_delivered,  'unixepoch', 'localtime', '+31 years') end as delivered,    
case when message.date_read=0 then null else datetime(message.date_read,  'unixepoch', 'localtime', '+31 years') end as read, 
    case when h1.id is not null then h1.id else h2.id end as interlocutor,
    case when message.is_from_me then null else message.text end as to_me,
    case when message.is_from_me then message.text else null end as from_me,
attachment.filename as attach,
    case when message.error=0 then null else message.error end as error_code
    from message 
    left join handle h1 on message.handle_id=h1.rowid
    left join message_attachment_join on message_attachment_join.message_id=message.rowid
    left join attachment on message_attachment_join.attachment_id=attachment.rowid
    left join  chat_message_join on chat_message_join.message_id=message.rowid
    left join  chat_handle_join  on chat_handle_join.chat_id=chat_message_join.chat_id
    left join  handle h2 on chat_handle_join.handle_id=h2.rowid

order by message.roWID

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.