extract contact photo from AddressBookImages.sqlitedb

Discussion in 'iPhone Tips, Help and Troubleshooting' started by romeoyankee, Nov 20, 2008.

  1. romeoyankee macrumors member

    Aug 27, 2008
    Long story short,

    I have a backup of my AddressBookImages.sqlitedb file from my iphone sitting on my computer.

    I also have my AddressBook.sqlitedb file

    Had to restore then completely redid my contacts because I found a way to sync them to hotmail/windows live which is what I wanted to do in the first place.

    The contact photos I wanted to use are no longer on my iphone or on my computer. I am assuming that they are in the AddressBookImages.sqlitedb file.

    How do I extract the images from that file. And yes I know I could put those old contacts back on the iPhone but I dont want to do that.

    Just want to take the photos out of that file.

    Can it be done and if so how?

    Thanks in advance!
  2. TESEV macrumors member


    Jun 1, 2006
    New Orleans, LA
    I'm trying to figure out how to do this as well. I got as far as finding the AddressBookImages.sqlitedb file but I don't know what to do with it or what I can open it with.
  3. TESEV macrumors member


    Jun 1, 2006
    New Orleans, LA
    I found out how to extract photos from the iPhone phonebook / contact list!

    The bad news is that if you have any precious photos taken using the phonebook, those photos will be thumbnail quality :(

    The good news is I've found a way to recover them so now at least you have them in all their thumbnail glory.

    I'll start from the top:
    1. You will need program a to extract an iPhone backup. The aptly named iPhone Backup Extractor will do.

    2. You will also require a .sqlitedb viewer. I used a Firefox add-on called SQLite Manager.
    You guys are using Firefox, right? :p

    3. Fire up iPhone Backup Extractor. Click the "Read Backups" button and pick a winner.
    Select and extract "iPhone OS Files".
    Remember where you parked it.
    Picture 1.png

    4. In Firefox, go to the Tools menu and click on SQLite Manager.
    Picture 2.png

    5. Click on this guy-> Picture 3.png and navigate to: [wherever you put the backup] > iPhone OS Files > Library > AddressBook > AddressBookImages.sqlitedb

    6. On the left pane expand "Tables" and click on "ABImage".
    Picture 4.png

    7. ....and here's the fun part :rolleyes:. In the main window every one of those entries is an image. For every picture you took in phonebook, phonebook saved about 3; the original, and one or two cropped versions.

    Now double click one of em. Scroll to the bottom of the window that pops up and click on the disk on the bottom right. Give your image a name and save yourself some time by adding ".jpg" to the end.

    A good idea is to name them by their appointed number so they are easier to keep track of. Cause if you have a lot of images like me step 7 gets old fast.

    Picture 5.png

    And the moral of the story boys and girls is to NEVER, EVER take photos with the phonebook.
  4. Musick7 macrumors newbie

    Jul 18, 2009
  5. rabbitEx macrumors newbie

    May 20, 2011
    Is there a way to export all the pictures together ?


    I referring to the data column that contains the pictures as blob.
    Is there a way to export the entire data column to separates files, one for each record ?

    Thanks !

Share This Page