By endolith


2010-10-17 23:11:50 8 Comments

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?

1 comments

@ryanklee 2010-11-12 00:04:53

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).

@endolith 2010-11-12 05:31:46

Would that automatically handle duplicates? I don't grok SQL.

@ryanklee 2010-11-12 12:01:15

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.

Related Questions

Sponsored Content

3 Answered Questions

[SOLVED] Running Android on a PC as a nondeveloper, just to run apps

1 Answered Questions

1 Answered Questions

HTC One SMS Backup File with no Extension Restore issue

  • 2017-01-17 13:21:47
  • Kamran
  • 719 View
  • 0 Score
  • 1 Answer
  • Tags:   sms restore htc

3 Answered Questions

[SOLVED] Combine/merge/concatenate/unsplit long SMS/text messages?

  • 2012-01-21 03:01:55
  • Dan Dascalescu
  • 12644 View
  • 2 Score
  • 3 Answer
  • Tags:   sms

1 Answered Questions

3 Answered Questions

[SOLVED] How can I merge SMS and Hangouts messages within Hangouts?

1 Answered Questions

[SOLVED] Backup/Restore SMS/MMS via ADB on a non-rooted device?

1 Answered Questions

[SOLVED] Recover deleted content from userdata partition?

Sponsored Content