Skip to Content

Great gifts for geeks, hand-picked by Download Squad
AOL Tech

Filed under: Hacks, iPhone

Scanning your iPhone Backup Files

Here's a nice way to recover notes from your iPhone without having to mail them to yourself--although it's not for the faint of heart. James Duncan Davidson located where iTunes stores its iPhone backup data--at least mostly. There's an error in his write-up. It's actually stored in your home folder's application support directory in MobileSync/Backup. For me, that works out to be /Users/ericasadun/Library/Application Support/MobileSync/Backup. But getting back to Duncan Davidson's story, he took a peek at those files and noticed they were some sort of compressed SQLite3 files.

Following on that, "Mr. Flip", who is one of the iPhone web developer Google group members posted this simple extraction utility written in Perl. When run, it converts each of the backup files to a normal well-named SQLite3 db file. Following Flip's directions, I then downloaded a copy of the OS X version of SQLite Browser from Sourceforge and used it to view the contents of the backup db files.

Interestingly enough, when viewing the db files directly from the command line (via sqlite3 notes_01.db and .dump) I discovered that the iPhone saved my entire history of edits for my note files as well as the actual final content.

Click here to read all TUAW’s iPhone coverage

Recent Posts

Reader Comments (Page 1 of 1)

Tip of the Day

Catch all of TUAW's ongoing Macworld coverage at www.tuaw.com/macworld2009


Follow us on Twitter!

Sponsored Links

Featured Galleries

DNC Macs
Macworld 2008 Keynote
Macworld 2008 Build-up
Google Earth for iPhone
Podcaster
Cucchiaio d'Argento
Scrabble for iPhone
Apple Vanity Plates
Apple booth Macworld 07
DiscPainter
2009CupertinoBus
Crash Bandicoot Nitro Kart 3D
Macworld Expo 2007 show floor
Apple Texas Hold 'Em
The Macworld Faithful in Line
iPhone First Look
Facebook 2 for iPhone
TUAW at Macworld 2009 -- North Hall
2009 Macworld Day One
Beejive 2.0
Aurora Feint

 

More Apple Analysis