More on iPhone Backups
Earlier today, by request, I posted about a way to restore your notes.db file after inadvertantly deleting it via a firmware upgrade. As several readers have pointed out, it's a lot easier to perform a full backup before the restore than trying to backtrack afterwards. Here's a quick forcing back-up how-to for the Mac.
1. Disconnect your iPhone from your Mac.
2. Navigate to Library/Application Support/MobileSync/Backup/ in your home folder.
3. Move all backup folders out of the way. If you're using Terminal, just mv them up to the parent directory. If you're using Finder, move them to your Desktop. It doesn't matter how you do this so long as the folders are moved before you reconnect your iPhone.
4. Connect your iPhone to your computer and sync normally. A fresh backup gets created in ~/Library/Application Support/MobileSync/Backup/. Go ahead and restore or upgrade your iPhone secure that your backup is recent and fresh. If you're especially paranoid, copy the new backup folder to a secure location.
Here is where your iPhone stores its key databases:
SMS. /var/root/Library/SMS/sms.db
Calendar. /var/root/Library/Calendar/Calendar.sqlitedb
Notes. /var/root/Library/Notes/notes.db
Call History. /var/root/Library/CallHistory/call_history.db
Address Book. /var/root/Library/AddressBook/AddressBook.sqlitedb and /var/root/Library/AddressBook/AddressBookImages.sqlitedb
Keychain. /var/root/Library/Keychains/keychain-#.db. The number varies.
Voicemail. /var/root/Library/Voicemail/voicemail.db. Individual voicemails are stored as 1.amr, 2.amr, etc. If you've recorded a custom greeting, it's stored as Greeting.amr.
In addition, Here are a few other folders to keep in mind:
Photos You can grab your recently snapped photos from /var/root/Media/DCIM/100Apple. Photos synced from iPhoto are stored in /private/var/root/Media/Photos.
Safari You'll find Safari bookmarks and history files in /var/root/Library/Bookmarks.plist and History.plist. Cookies are stored in /var/root/Library/Cookies/Cookies.plist.
Email If you want to back up email, it's not straightforward. The files are stored in /var/root/Library/Mail however attachments are mime encoded (stored in /var/root/Library/Mail/(account name)/INBOX.mbox/Messages) and the "Envelope Index" folder is actually an sqlite db storing information about those attachments.

Get a WordPress.com Blog
![TUAW [Cafepress]](http://www.blogsmithmedia.com/www.tuaw.com/media/tuaw-cafepress-promo.png)


Reader Comments (Page 1 of 1)
tarzxf said 8:13PM on 8-22-2007
M-m-m-my Bologna!
Reply
Reg Muffet said 9:26PM on 8-22-2007
Whoever doesn't love Erica now after today's extremely useful posts, particularly the awe-inspiring "squirting for iPhones" one, should be officially made to stand in a corner.
Reply
(01) said 10:48PM on 8-22-2007
Your phones name is "Bologna"? Now you just need to find the person who has the "white bread" one...
Reply
iTaly said 7:51AM on 8-23-2007
http://en.wikipedia.org/wiki/Bologna
Reply
1771 said 6:06PM on 10-01-2007
I'm looking for more in depth information about AddressBookImages.sqlitedb in order to know how to get the thumbnail for a given contact.
Any clue?
Thanks
Reply