My sister lost her iPhone a couple of days back and with that all her contacts, notes and calender entries that she had painstakingly stored on the device.
Her only hope of getting all that important data back was the backup that she had taken a couple of days earlier and she asked me to help her out.
Well, truth be told. The iPhone is not the most open among gadgets. And it isn’t easy to get your data off it. Apple has tried it’s best to hide any iPhone related information from the user’s view. And they have succeeded to an extent, atleast the primary consumers of Apple’s goods don’t really care where (or more importantly, how) the data is stored, as long as Apple provides an application to access it.
In the iPhone’s case, the application is iTunes and the only way to put this data back on to the device is to use iTunes … unless you know where to look for it.
On a computer running windows vista, the data backup is stored in the following location:
C:\Documents and Settings\USERNAME\Application Data\Apple Computer\MobileSync\Backup
Under the backup directory, you will see a directory which looks like a unique ID. This is the directory in which the backup is created, everytime you backup your iPhone using iTunes.
In this directory, you will see a number of files with the *.mdbackup extension.
The .mdbackup files are the actual backups of all the applications and settings of your iPhone. So, the first thing you should be doing is, make a backup of these files :-)
If you use an editor to view these files right now, all you’ll see is garbage, cause these are not text files. They are what Apple calls Binary plists. And to decrypt them, you ideally need a Mac and this utility.
I used the command line version of the utility since I only had console access to a mac and that worked for me.
I first copied all the *.mdbackup files, that I had collected from the iTunes backup folder, to the Mac and ran the following command to zero in on the files that actually had any useful data. I was the most interested in the Contacts data, so that’s what I searched for first.
grep ‘AddressBook’ *.mdbackup
AddressBook is the name of the application which stores, well, address book data on an iPhone. It is only named Contacts in the interface. The actual application name is AddressBook and when I searched for that string in the backup files, I got three files as a result.
I opened the first file using a text editor and it turned out to be the one I was interested in. The word AddressBook is in the beginning of this binary file and it also mentions the database name, where all the data is stored. Yay !
So, now to get to that data base file, we need to use the decoding utility that we downloaded earlier.
So, we’ve got our database file. The decode iphone utility will put it in the following folder structure
/Users/<username>/MobileSyncExport/Library/AddressBook/
Open the database with the following command:
sqlite3 AddressBook.sqlite
and you’ll be dropped to the sqlite prompt. At this point, you need to understand the schema of this database a bit before you can proceed further. Give “.tables” command and you should see the following output.
At this point, I had to use a bit of trial and error to figure out which table holds what data. To view the schema of a particular table you can use the following command.
.schema <table name>
Using this command on the ABPerson table gave me the following result.
There was other information also, but this is basically what I was interested in. So, this particular table was all the information about the a Person, except the phone number. To look for the phone number, I had to look at another table – ABMultiValue. And the two tables are linked through the ROWID and record_id fields in the ABPerson and ABMultiValue tables respectively.
It turns out that the ABMultiValue tables lists all the phone numbers and a quick “select * from ABMultiValue” gave me the answer I was looking for. So, now I finally know where all the data is. To collect all the data in a single place, I used the following SQL query.
select ABPerson.first,ABPerson.last,ABMultiValue.value from ABPerson,ABMultiValue where ABMultiValue.record_id=ABPerson.ROWID
Once I’d confirmed that this was indeed the correct data, I gave the following command on the sqlite prompt
.output backup.txt
That made sqlite put all output into the backup.txt text file rather than the console. And I was set. Ran the above select statement once again and I had all the phone numbers in a nice text file.
How was that for a weekend project, eh ?
In a future post, we’ll talk about taking out the notes and Calender entries from a backup file. The procedure is almost the same, so if you guys can figure it out yourself till then, post the solution in the comments.
|
About: Sharninder: Programmer, blogger and a geek making a living shifting bits around the Internet. Sharninder is the owner of Geeky Ninja |
![[Mac] How To use Automator to Test your Website’s iPhone version](http://geekyninja.com/wp-content/themes/bigfoot/includes/timthumb.php?src= http://geekyninja.com/wp-content/uploads/2010/03/automator-iphone.gif &h=48&w=48&zc=1)
interesting post.. tell me a way to doing it in Windows.. then it will be more cool ..hehe
I did find a couple of tools to decrypt the binary plist in windows, but none of them worked for me. That part I had to do on a Mac. The rest is pretty standard stuff. sqlite is available for Windows, so you might want to try that out.
If you’re on a Mac anyhow, I found a couple of tools that will grab texts and voicemails off of the iPhone backups automatically. Fairly nice for a techno-phobe like me! The tools are Decipher VoiceMail and Decipher TextMessage… http://decipher-media.com/iphone-tools/
I am the one who lost the Iphone.. but bhaiya… NO CLUE it was sooo freakin hard.. i mean.. i got it only till the time u said u need something in mac.. heheh..
i stopped there.. i dont have one..
hehehe
but thanks tho.. i really needed those contacts.. :)
All I need to do in my phone is to copy the PIM file.
@abhilash: Lucky you :-)
interesting, but any way to do this in winDOZE
Except for the first part, of decrypting the .mdbackup file, rest everything can be done on Windows. sqlite tools are available for windows. Actually I did find a script to decrypt the binary plist file in windows also, but for some reason it didn’t work for me, so I used a mac.
Dude I just used iphone backup decoder on a Mac which u have linked here and its just point and click to get the stuff back but it only gives you sqldb’s so from there onwards have to follow your tip. Works great. thanks.
@Raj: Glad you found the post useful.
If you have multiple phone numbers it lists it as another contact with the 2nd/3rd number… is there are a way to have it consolidated into one row?
Thanks
@Bradley: Yes, the multiple phone numbers come as seperate entries but this is just a text file that you’re getting. I don’t think there is anything that can be done about this.
Look on the brighter side though, you don’t lose any data :-)
Hey man, great article, I’ve used this procedure numerous times to help friends with recovering phone numbers from smashed iPhones, making retraceable backups that wouldn’t restore their entire system software (don’t ask why), etc. Anyway, I just wanted to clarify that last part on exporting to .txt. Is there a specific DBMS that does that? I’m on SQLite Database Browser 1.3 for Mac OS X Leopard and it doesn’t seem to cooperate with that last command, could I just be doing it wrong? If you have any idea what’s going on, would be great to hear it straight from you.
Thx in advance…
@Vikesh: Is the SQLite database browser a GUI tool ? I’m asking because I didn’t use any GUI tools for this purpose. I opened the database using the sqlite3 command line utility. Just drop into Terminal.app and follow my instructions.
Hmm, this almost works for me, working in terminal in 10.5.5.
Neither the “.select” nor “,output” seem to perform any function. They just bring up a …> prompt.
Thanks for this article, BTW… it’s been very helpful.
@sktz: The prompt that you’re getting is because sqlite is expecting you to close the last statement. Did you give the full command as -
“output backup.txt”
(Without the quotes)
If that didn’t work, try adding a semi colon (;) at the end of the statement.
Or else, try googling for some gui browsers for sqlite3. I have one which works for windows:
http://sqlitebrowser.sourceforge.net/screenshots.html
Try this on a windows machine if it works for you.
Hi Sharninder,
I was extremely interested in this article, thank you for posting your tips on here. I am in the same position, I am using SQLite browser to veiw the backup data (or at least the Contacts tables) and tried your SQL query “select ABPerson.first,ABPerson.last,ABMultiValue.value from ABPerson,ABMultiValue where ABMultiValue.record_id=ABPerson.ROWID
” to group the data together. However, ultimately I would like to export the results into another format, ie. txt document or other, but running your SQL statement “.output backup.txt” brought up the error, “no such column: ABPerson.ROWID.output” – not sure what I am doing wrong, but if you have any ideas, I would love to try them out. :)
The output command has to be given on a seperate line. And you have to give the select command after that for the output of select to into the given file.
Sharninder,
Thank a lot. I appreciate your help. It turns out the issue was, as you suggested, closing with a “;”
I’m still unable to get it outputted into a text file, but the results do come up in the terminal, and I can just copy-paste them.
This is extremely helpful. Hats off to you.
Thanks for the great article! I’ve been extracting SMS messages from an IPHONE backup, and am struggling to understand the DATE format. See sample below. I think the actual message date in this example is around 12/30/2009. Any idea of the exact format meaning?
DATE MESSAGE
1230221228 Hello
1230223075 What up
1230223125 Txting you on my new phone
1230223243 Sweet… How was your christmas?
1230223294 Merry Christmas girl!!! I got a new phone!!
Thanks much!!
1230223349 Delightful when can I see you
John,
I also haven’t been able to figure out the date format although, I admit I haven’t looked too hard. Since, I was mainly concerned with the data, once I had that, I didn’t bother with the dates. I’ll do some more research on this and if I find something interesting, I’ll update this post.
Those date numbers are “Unix time” i.e. seconds since 1970-01-01T00:00:00Z.
They range from 2008-12-25T16:07:08Z to 16:42:29 on the same day.
Unlikely to be December 30, 2009 because (1) that’s in the future (2) one doesn’t wish one’s gf “Merry Christmas” 5 days late and hope to retain the relationship :-)
HTH
John
Yes, I also thought that was Unix time, and converted some sample dates from my phone but couldn’t still get the actual date. I could figure out the date but the year was off by a couple of decades :-) I think I need to look at this again to get a fresh perspective.
Hmm, i’ve opened an sms.db file, but didn’t find there DELETED messages. Only same as on my iphone.
If the messages have been deleted from the phone, I don’t think there is any way to get them back.
@john: “i’ve opened an sms.db file, but didn’t find there DELETED messages. Only same as on my iphone.” Where did you get the sms.db from? opened it with what? what did you do to try to find deleted messages? what is the same as on your iPhone?
@Sharninder: depends on how they were deleted. I have helped dig out almost all of an address book db which was not backed up and whose contents had been thrown away by syncing it with an empty outlook db. If you can get the sqlite db off the phone and examine it with a hex editor and see lots of names and “c u l8r” etc etc then there is a good chance of dragging out most of the contents into a text file or into another db where you can play with sql and put it all back together.
To John Machin: I need a message that I’ve deleted 24 hours ago by “clear conversation”. I don’t have this message in last itunes backup, so my only chance is a new backup. I extracted OS files via “iPhone Backup Extractor” and found an sms.db file there. Than I’ve opened it via sqlitebrowser-1.3.
And I didn’t find there any deleted messages, only same messages which are currently available on iPhone. There are missed ID’s in the db table. So I suppose there’s no chance to recover deleted messages. Sorry for my English.
@john: sqlitebrowser makes no pretence of being able to show the remains (if any) of deleted database rows. Of course you would only see the same as you can see via the iPhone. Use a hex editor or a simple text editor or the Unix strings command — anything that does NOT understand sqlite structures and will thus show you ALL of what is in the file. Depending on what else has happened to the database after the sqlite deletion, you have a reasonable chance of seeing the contents of your deleted message there.
@John Machin: Aah ! I get it now. You’re using a hex editor to actually get text out of the db file. That might or might not work depending on how *old* the data is that one wants to recover, but yes that’s a good method to use if one is really desperate :-)
@Sharninder: No, I’m NOT “using a hex editor to actually get text out of the db file”. I’m talking about using a hex editor or somesuch to INSPECT the file to SEE if there is text there that is not visible when you use a program that interprets the file as a SQLite database. In john’s case, his one missing SMS message may be visible in the file, and that’s all he needs. For any quantity of data (like the several hundred contacts covering many columns and several tables that were recovered from the iPhone contacts db) attempting to recover it using a hex editor would be extremely futile.
@John Machin: Yes, I agree this technique is quite good for getting atleast something out of the db file. Recovering the full contents would be quite tedious.
@John Machin: Yeah, the first I did I opened .db file with text edit on mac. The whole text I found was same, nothing hided.
@john: Bad luck, it must have been over-written; SQLite is rather aggressive about using free space instead of extending the file — a very good idea in /normal/ operations.
@Sharninder: Recovering the full contents (more likely: /near/ full) of a TINY db would be extremely tedious if done with a hex editor. Have you ever looked into the SQLite file format (http://www.sqlite.org/fileformat.html) ? However it’s not tedious at all when you have a /program/ to do it.
Hi:
i backed up my sms from my iphone to a “text file” with phoneview (wrong idea)!
now, i have the 3.0 SW and i want to recover those messages!
ther is a way to do that??
thank yo very much!
I haven’t used phone view so I can’t help with that. I don’t think there is a way to directly recover sms messages from a text file to the iphone.
Hi, thanks for ur guide, it really helped!
Can you make a guide for calendar and text messages and notes? Thanks
Jeobob,
The last time I tried, I was more interested in the contacts so only worked on getting those. I’ll try write up a guide for recovering text messages and notes too later sometime.
@harninder: I have read your article but I don’t a mac. Could you please tell me which tool did you use on Windows? You said they didn’t work but I would like give them a try.
I’m so desperate to recover my contacts! really really.
Thanks for your time.
@Mirle: Try this link:
http://discussions.apple.com/thread.jspa?messageID=8614248
http://tech.kateva.org/2008/08/iphone-backups-are-stored-in.html
http://code.google.com/p/mobilesync-inspect/source/browse/trunk/USAGE.txt
Not sure if they’ll be of any help to you. Don’t you have any friend with access to a Mac ?
Hey!
you don’t necessarily need a mac, any kind of *nix is good and as various people already said, windows is good aswell. Well I was hoping for a gui but then again I finished recovering my data with sqlite3 as you nicely described on a linux centos server, and all is nice now :D yaay!
Thank you!
@Ciprian: Yes, any windows or unix computer is fine for reading the sqlite files. I used the mac to decode the binary plist file. If that can be done on windows, nothing like it.
i guess you can say i am a noob, but i want to get my contact list to and i dont really know much about how the decoder works.. could you help me alittle?
Just run the decoder with the name of the .mdbackup file and it’ll produce the sqlite files as output.
decode_backup… MdbackupFileName.mdbackup
You can use the iPhone Backup Extractor at http://reincubate.com/labs/iphonebe to extract this data — there’s a free version. Hope this helps.
I have updated my iphone in my friend’s computer.Now I am unable to get my old contacts telephone no. and notes.Here after I have done syncing several time s in my computer after that.Now can I get that contacts list from my computer again?can I restore contacts from 1 month old backup so I can get full contacts details?
Unless your friend has removed iTunes and the backups on his computer and/or uses another iPhone on his computer also, you should be able connect your iPhone to the other computer and just select restore from backup.
On your friend’s computer, go to Edit->Preferences and look under the Devices tab. This’ll show you the backups that are still available on the computer. If your backup is still there, you can restore to it. If it’s gone, then you can’d do much about it.
Thanks for the tip. I was to use sqlite3 command line utility in windows to access my contacts data from backup to a text file, following your steps above. The instructions were very clear once I read them :))
This is an amazing tutorial, thank you so much for sharing! I just have one questions – I am using SQlite browse & I am able to execute the query & see the contacts nicely but the problem is how do I export it? When I click on export it is only giving me the option of exporting the “AB Person” or “AB multi value” but I need to have it export the combination just the way your query is.
Pamela,
My article is useful for those who want to understand some of the inner workings of iPhone’s backup files. If you’re an end user only interested in getting your data out, I’d suggest that you take a look at the iPhone Backup Extractor application from reincubate.
If you can’t get it to work, let me know and I’ll try and help you.
Hey i’ve been looking all over for a solution to my creativity…I was @ a friend’s house out of town (windows Vista) and decided to update my iphone software ( i know…i should’ve known better!!!). Any way when i plugged the phone to update the software, it automatically backed up it. In the process of synching it failed and left my phone in recovery mode.
I had a previous backup on my Mac at home and had to restore my phone with that one meanwhile because it was on recovery mode and i need a functioning phone.
I know where the backup is stored on a vista pc, the question is if he can send it to me by email, cd, etc and can i copy it onto my MAC (library/app support/mobilesync/backup) and then restore my phone with it????
I don’t want to loose 1 year since my last backup . Please help…..
Hi Alex,
I’ve not really tried this but it might just work. The only way for you to find out is to actually try copying the backup to the backups folder and see if iTunes recognizes it. You’ve got nothing to loose. If iTunes recognizes the backup then it’ll work, or else you’ll have to get the data out of the files manually as described in my post.
Let me know if it works or not.
Yes, you can use a backup file from iTunes on any other PC: the iPhone Backup Extractor (iphonebackupextractor.com) will be able to read it on Mac or Windows.
I rescued the mysterious loss of some calendar appointments using the following steps:
(From an iPhone running OS 3.1.2)
* Ran iPhoneBackupExtractor on my iTunes backup file
* Extracted Library/Calendar/Calendar.sqlitedb
* Opened using free Firefox Addon SQL Lite Manager
* Browsed the Event Table
* Selected the records I wanted to recover, right-clicked and copied as CSV (Excel compatible)
* Pasted into MS Excel
Recovering the original dates and times was quite confusing. I thought the times should have been seconds since 1/1/1970, but it seems mine were seconds since 1/1/2001. So I created a new column with this formula:
=”1/1/2001″ + F1/60/60/24 + 11/24
This assumes your number is in cell F1 (e.g. 281577600). The middle part converts the seconds to days (required for Excel) and the last bit adds 11 hours (because I’m in Eastern Australia timezone). This should give you the original dates and times back. You can then import those dates into Outlook, or your other calendar app.
Hope that helps someone.
Simon.
I know it’s been a while since you posted this but wanted to say thanks. I had a hard time finding the date conversion formula. Yours works perfectly!
Hello!
Great tutorial!
I was wondering…
Since i’m not the only one with this problem, maybe you could help a lot of people with that.
I have an iPhone 3GS with the new bootrom (tethered jailbreak) I rebooted it and now i can’t get it back to work with blackra1n. So im stuck with either an jailbreaked and unlocked 3.1.2 or i upgrade to 3.1.3 and wait what will come…
Anyway! I do have an backup of my entire phone. And since i didn’t backup my ECID SHSH i was wondering, if it’s possible to get those informations out of the backup?
My second question…
Is it possible to access the phone while it is in recovery mode? I want to get in and delete some files i installed, which may be the cause of my problem.
Thanks in advance for your help!
Sorry for the delayed response. I’ve been a bit busy in the offline world.
The short answer to both your questions is that I don’t know the answers. The long answer is that as far as I know the SHSH hash is only required to unlock the baseband. If you already have a backup of the data, that should be in regular sqlite and you should be able to use this guide to get your data out. There is anyway no harm in trying, right ? So try out and let us know how it goes.
The second question is the more difficult one since I don’t have an iPhone 3GS to actually try this scenario out, but if your phone is in recovery mode, I don’t think you can get in it. Getting access to the filesystem requires jailbreaking and the full iPhone OS to be running which it isn’t in your case.
i have apple iphone but i make mistack i make ereae all from my phone now its come blank
i wont some thing for my iphone
I’m sorry but it is difficult to understand what you’ve written. From what I understand, you have erased everything from your iPhone and want some of the data back. Am I right ?
If you have an older itunes backup and you follow this guide, you might be able to recover some of your data.
Hi all,
i have lost my 900 contacts by clicking on erase contact icon on my phone. its a stupid application which didnt even asked before deleting all my contacts. it was there in the phone already as i had bought the phone from a friend. is there any way i can get all those contacts back. i’m using a windows machine with itunes 9.1 i have alraedy done a restore using itunes but it was of no good. plz help.
If you have the backup files then you might be able to get some of your contacts back using the instructions in this guide, but only if you’d made a backup using iTunes before deleting the contacts. If you didn’t backup earleir, I’m afraid I can’t help you.
Enormously helpful to those of us who have lost or destroyed our iPhone in some way :/
I was able to get this to work under Windows Vista with a few minor modifications. You don’t really need to use the Python script, but you will need to grab the sqlite3 binary from somewhere (preferably the sqlite website.) And Cygwin is helpful but not required.
You basically want to look for the encrypted files in C:\Users\UserName\AppData\Roaming\Apple Computer\MobileSync\Backup\. You want to search/grep for the file that contains the AddressBook.sqlitedbS1 line, but under Vista at least, there will be two files: a .mdinfo and a .mddata file that have the same name, as opposed to the one .mdbackup file. The AddressBook.sqllitedbS1 string will be in the .mdinfo file where the corresponding .mddata file is actually the sqlite database. You can pass this file (preferably a backup or copy) to sqlite3.exe and then run the same output and SELECT statement that you do.
Thanks for the Kind words and the tip Scott.
Use iTwin for that and more. Nice and easy … http://www.i-twin.de/en
Use the following SQL to get rid of duplicates.
select distinct ABPerson.first,ABPerson.last,ABMultiValue.value from ABPerson,ABMultiValue where ABMultiValue.record_id=ABPerson.ROWID
Great article! Using SQL Browser + iphonebackup extractor to get the sql db off a recovered backed.
I know it’s been a while since you created the original entry, but you don’t actually have to play around with the Terminal even if you aren’t accessing the files on the computer where it was backed up.
If you just place the backup folder where it would be if you had backed it up on your Mac the software reads it just fine. Though it’s still full of SQL-y goodness.
on win 7 the folder should be
C:\ProgramData\Apple\Lockdown
but i did not yet tried to recovery the data
I had to do a backup and then restore my iphone. They had me load it as a new phone because they had originally thought it was a corrupt file on the phone causing problems. Eventually, I was given a new iphone. My favorite game, Tap Tap Revenge 2, was wiped out. All the songs that I loved were no longer in the app. I’m sure it’s in the backup file somewhere. Any chance you can tell me how to find it and put it back on my iphone the way it was??? It’s really the only app I need to do this for, and I have so many more on this new phone that I would rather not restore it to the old one and risk losing everything I have now. I do have a mac if that helps. Thanks!!!
Read mostly all the comments… Would appreciate any help possible…
I have a 3gs (bought in dec09). I have never synced my phone to my itunes and now my phone has crashed. Apple store tells me that I have to restore and will lose everything.. Will following the above mentioned by Sharninder help me recover my contacts? Thanks in advance
best article yet that I have found in 3 days searching… i hope this helps me..
Since, you have never synced with iTunes, you won’t have an older backup but ideally when you restore through iTunes, the software first creates a backup of the phone and then installs the firmware. BUT, since your phone has crashed, I’m not sure how iTunes will behave in your case. If it does take a backup, you can get your contacts back following these instructions. If it doesn’t, well, you were going to lose everything on the phone anyway in the first place.
I had success with this just now using the trial version of “Iphone Backup Extractor” extracting the “AddressBook.sqlitedb” file from my “Library” folder then downloading/installing the Windows version of sqlite3 (http://mislav.uniqpath.com/rails/install-sqlite3/). From there just playing around with the above. Thanks! My iphone isn’t cooperating with me currently and this saved me a lot of heartache. :D
The thing is I’m going truly crazy at this second. Yesterday idiot me, was in a hurry and when I connected my iphone 3G with my itunes, which i haven’t done in the last 4 months.. again idiot me, and the update to software to 4.0.1 just popped up on the screen, and I just said yeah, whatever and clicked go on man! Really, I should be out of my mind because I always check those things and try to back up it before any update because of the things that I’m afraid might happen. And to my idiot luck it did happen… :( It said while it was updating that it was backing up the phone. So I went to sleep and left it open so that it can download on its own, and in the morning I just get it off the itunes and went to work. Then remembered to check my messages just to see an empty page. Shock! Then I came back home hoping I can restore my phone from the backup it had yesterday, but again to my luck, the idiot itunes hadn’t backed it up yesterday, I mean when I said back up today it just backed up to the four months before backup. In other words,I want my messages, and contacts back!!!Pleaaseee helpp, they were soo important to me. Please I just couldn’t understand what to do, helppp :( Please?
Joey, you can try and check the iTunes backup folder to see if iTunes did actually make a backup of your device or not. Other than that, I’m not sure if I can be of any help to you. If the iTunes backup wasn’t made at all for some reason, then I don’t think you can recover your data, considering that you’ve already flashed a new firmware.
i’m in the midst of a situation that seems similar but i guess i don’t know macs well enough to recuperate my data. basically my ipod died, but i was able to sync it first. i plugged the new one in, and it insisted on updating the itunes before it synched with my data, and then it would *not* properly sync with my previously stored data on the computer. instead, it created a separate persona. so while i gained all my applications, i did not regain all the passwords for them. i did get my contacts back. unfortunately the one most important thing i need is some info i wrote in notes.
i did what you said, i found the mobile sync backup from the correct day, and using the utility (this is all on a mac) i bring up that data and i can put it into a folder on my stupid apple desktop. but it does not have any contacts/notes — only applications that i put on the ipod. is the notes data still there somewhere? i recently restored a bunch of data off my ancient ipod onto a pc, but obviously macs are not as easy to work with : (
btw itunes does give me the option to restore and sync it with the old version of my ipod contents, but then it gives an error message and although it’s synching, it does not come up with the stuff i saved on it. it syncs as though it were brand new and just retrieving the apps off the computer.
the apple store was nasty, and unhelpful on this issue, of course. and they gloated about how my warranty ran out friday. (classic!)
Sonia, If you’re sure you’re looking at the correct backup file, try using the graphical tool – sqlite browser http://sourceforge.net/projects/sqlitebrowser/files/ to look at the data. When you’re sure this is the data you want, use the “select” query that I’ve given to get that data in a text file on your desktop.
Sharminder, thanks for such a great site! Quick question, I have an iPhone 3GS OS 4.0.1 that has never been jailbroken (and apparently can’t be at this moment). I want to delete some of the autofill email address entries in my mail program (my phone pulls email from my gmail account) but nothing works to do this. I used the iPhoneBackupExtractor to download the AddressBook.sqlitedb file and manually deleted the entries using Visual SQLite.
My question now is do you know how I replace the original file with my modified file?
Short answer: I don’t know.
Long answer: You might be able to re-encode the Addressbook and put it back at the same location “on the iPhone” but that’s only possible if it’s jailbroken. Even then I don’t think those autofill entries come from the address book, I think the mail client keeps them in a separate db of it’s own, which I haven’t really explored.
Bloody brilliant article, mate!