poniedziałek, 17 sierpnia 2009

restore contacts from apple iphone backup files (made with itunes)

My friend's iphone has been totaly jailbreaked :) (see photo below :P), he would love to get data back from it, the only files he had was iTunes Backup. I found the method to turn iphone backup databases into readable sqlite (see: TUAW) using this tool. Bacause First and Lastname are stored in AbPerson and phone number (as value) is stored ABMultiValue constructed SQL query to show everything line by line looks like this:
select p.first, p.last, v.value from ABMultiValue v, AbPerson p where v.uid = p.rowid


0 komentarze: