Take the 2-minute tour ×
Android Enthusiasts Stack Exchange is a question and answer site for enthusiasts and power users of the Android operating system. It's 100% free, no registration required.

I have a lot of problems with my phone, and so I have a number of nandroid backups with different sets of overlapping SMS messages saved in them. I've also made a few copies of the data folder when the thing wouldn't boot. I like to have all my SMSes backed up to my Gmail for posterity and searchability, using SMS Backup Plus.

What's the easiest way to recover messages (and maybe other data) from my backups? Is it possible to open or run nandroid backups inside an emulator? Are they in a format that can be extracted to a filesystem, and then take the database files out and merge them with some kind of database tool and then put the merged file on my phone? Would it handle duplicates?

share|improve this question
add comment

1 Answer 1

I believe /data/data/com.android.providers.telephony/databases/mmssms.db is an SQLite DB, so you can use this firefox add-on, SQLite Manager and that should let you merge whatever backups you have lying around rather easily.

After you merge them, you can just replace /data/data/com.android.providers.telephony/databases/mmssms.db with the resultant merged file (backup the oringal first).

share|improve this answer
    
Would that automatically handle duplicates? I don't grok SQL. –  endolith Nov 12 '10 at 5:31
    
It depends on the manager. The feature list is here` code.google.com/p/sqlite-manager` At the very least it will take some monkeying around. But it seems like DB manager with an eye towards ease-of-use, so it shouldn't be too difficult. My guess is that you'll just do a series of imports on the backups and then save your master list to copy back to the database dir on your phone. –  ryanklee Nov 12 '10 at 12:01
add comment

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.