After a complicated chain of circumstances involving a SIM migration, a grandfathered prepaid data plan that transferred from an iPhone 3G to a 4 to the current 5S, and many hours (no exaggeration) at the AT&T store while their employees talked to level 2 tech support, I was left with:
an option to restore the entire phone from the backup. Help me restore just the user data for selected apps.
I've migrated to a new nano SIM but restoring a backup to the phone immediately drops it off the data network. (There's no good explanation, probably because what used to be an AT&T loophole is now official but migrating from loophole to official status is not supported?) I'm stuck with "restore to factory settings" followed by a manual re-installation of all my apps, music, etc.
The damage is surprisingly light: most apps had stuff squirreled away in iCloud or elsewhere online; I offloaded all photos and videos before the wipe; calendars, mail, podcasts and music came back correctly; I don't care very much about the lost text message conversations; and I'm resigned to losing all my progress on Angry Birds etc. The serious damage boils down to two apps (so far): Growth
(tracking my daughter's height / weight over the first two years - I neglected to export this, shame on me) and my notes in Vesper
(which famously lacks sync
). I'd like to get the data back for these apps.
I've discovered a variety of applications that read backups (even encrypted ones). iPhone backup extractor
worked well enough; this one (same name)
looked pretty awful but got the job sort-of done; there were many others that I didn't try. It worries me that the extracted files seem to differ between the two programs. But in any case, now what?
1. I have these SQLite databases extracted from the last backup. Can I put these back into the apps on my phone again? How?
2. Alternatively, is there a different way to do a partial restore, where I only restore selected app data from a backup to my phone without
fiddling with anything else, especially settings and carrier profiles?
3. Failing that, how do I export from the SQLite databases to plain text in a non-soul crushing way? (I have a factory-unlocked phone, but it isn't jailbroken. I'm not interested in jailbreaking the phone - if it comes to that, I'd rather have the data in plain text to re-input by hand.)
Hope me, Metafilter!