AddressBook.sqlitedb Redaer

[allanes5]

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?

[Mes]

SQLite Manager plug-in for Firefox works great.

sqlite-manager - Project Hosting on Google Code

[allanes5]

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

[dhamien]

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

[allanes5]

Thanks dhamien

gonna check these