1. allanes5's Avatar
    I copied the AddressBooksqlite.db files from my 3gs before it got stolen.

    I've tried to copy them back to my iphone 4 via ssh but it does not read them.

    Is there a program that can read these sqlitedb files so I can at least manualy re-enter my contacts?
    2010-09-23 05:47 PM
  2. Mes's Avatar
    SQLite Manager plug-in for Firefox works great.

    sqlite-manager - Project Hosting on Google Code
    2010-09-23 06:01 PM
  3. allanes5's Avatar
    SQLite Manager plug-in for Firefox works great.

    sqlite-manager - Project Hosting on Google Code
    Thanks.

    I've installed the plug-in and opened it via tools tab from the FireFox Page.

    Now ust have to figure out how to open the file because when I do I get a:

    Master Table (1)
    Table (18)
    Views (0)
    Indexes (20)
    Triggers (8)

    But I can't get my contacts and phone numbers
    2010-09-23 08:03 PM
  4. dhamien's Avatar
    You can read it using Total Commander if you install the SQLite reader plugin. You can find the plugin in the very last post on this page: Total Commander :: View topic - SQLite lister plugin

    About just moving it to your new i4, did you make sure the file permissions and ownership was correct? For reference, on my 3GS on 3.1.2 the permissions are:

    /var/mobile/Library/AddressBook [folder]
    Ownership
    Owner: mobile
    Group: mobile

    Access Permissions
    User: Read, Write, Execute
    Group: Read, Write, Execute
    World: Read, Write, Execute

    /var/mobile/Library/AddressBook/AddressBook.sqlitedb [file]
    Ownership
    Owner: mobile
    Group: mobile

    Access Permissions
    User: Read, Write
    Group: Read
    World: Read

    /var/mobile/Library/AddressBook/AddressBookImages.sqlitedb [file]
    Ownership
    Owner: mobile
    Group: mobile

    Access Permissions
    User: Read, Write
    Group: Read
    World: none
    We're all just toymakers in the game of life.
    2010-09-24 12:58 AM
  5. allanes5's Avatar
    Thanks dhamien

    gonna check these
    2010-09-24 01:26 AM
LINK TO POST COPIED TO CLIPBOARD