Addressbook.sqlitedb and sms.db on iOS 5. Upgrading problems.

[DaMan05]

When the owner is root, effectively you prevent any (but root) from changing the file. Naturally, when you set it to mobile, changes are allowed to the file by any...
To clarify further, all saves or changes (as an example of a save game file) has to be set as mobile to have access to the read & write...

Do your received iMessages have a timestamp of the year 2042, by any chance?

[anhvinhbeo]

Just did with my 4.3.3 ==> 5.0.1
how to do it:
1. Delete everything from Addressbook/SMS
2. Copy over the old database
3. Change owner from "root" to "mobile"
4. Respring or reboot

[Trees415]

Hi,

Yesterday I just tried to update my iPhone 4 4.3.3 (jailbroken with Jailbreakme) to iOS 5 but had some problems with corrupt iTunes backup and couldn't restore my old data back into iOS 5. Thankfully I had a manual backup of some of the most important files I had on the phone (address book and sms data) which I'm trying restore to iOS 5 now.

When I migrated from iPhone 3G 3.1.2 to iPhone 4 4.1 I had a similar problem and just cutting and pasting the old files to the new OS (on /var/root/library/addressbook and /sms respectively) worked just fine.

However, address book data used to consist of only two files: AddressBook.sqlitedb and AddressBookImages.sqlitedb. And SMS had only sms.db. However on iOS 5 there are three "versions" for each of those file (AddressBook.sqlitedb, AddressBook.sqlitedb-shm, AddressBook.sqlitedb-wal, AddressBookImages.sqlitedb, AddressBookImages.sqlitedb-shm, AddressBookImages.sqlitedb-wal, sms.sqlitedb, sms.sqlitedb-shm, sms.sqlitedb-wal)
It seems the actual contacts/sms are storred on the .sqlitedb-wal files and not the .sqlitedb ones.

Trying to replace the .sqlitedb files or renaming them to sqlitedb-wal and replacing doesn't work.

Does anyone have any clues on how to proceed on this?
Thanks!

You should check out a tool called iPhone Backup Extractor, it's incredibly useful if you're having trouble restoring your iPhone content (like contacts, sms, photos, etc) using an Itunes backup. It will simply extract all of the files for all those things, which you can then take and manually install into your newly updated iphone using winscp or iphonebrowser. Unfortunately, it costs money, though I believe they offer a free trial as well.
Another tool I'd suggest for people to checkout if they are looking for a good iphone explorer is a program called iSpirit. iSpirit accesses iDevices via USB, and has all the caveats that are available to WinSCP users. It's not a very widely known tool, but it is probably the best one i have used thus far.

It's a shame there still isn't a viable backup/restore tool to use when updating iOS firmware.

[AnArChYm]

Hey guys,

I tried the same way you said and I still can't import my backup of address book, at least I managed Notes, SMS, calendar and photos

Please help me as the contacts are the most important

Thanks

[DaMan05]

I can't help you with your problem, but in the future, wouldn't it just be easier to use iCloud, sync with your desktop, an Exchange server, Gmail or any of the other billion services there are that can backup your contacts?

Personally, I use my school's exchange server for syncing contacts, calendars and tasks/Reminders. I dunno what I would do if my laptop and phone didn't stay in sync constantly... especially the tasks.

[codvisp]

Do your received iMessages have a timestamp of the year 2042, by any chance?

Nope all is well & 100% working with a correct date...

[codvisp]

Can i just add a couple things

- If you are stuck in the cycle where it keeps respringing automatically. Just delete the contents of SMS/ and then start the above process once booted AND BEFORE ANY APPS ARE LOADED

- In my particular situation, i could restore the SMS database fine, and see all the messages, but when i tried to send one, or receive one, the phone would crash and wipe the database again. There is a point above that rebooting fixed this. However, my situation is also this, once restored, if i re-boot, the phone hangs on the lock screen, and then refreshes, with no SMS. So rebooting in my case, no matter what sequence i tried, with all the correct permissions, my database just wanted to wipe!

If you find yourself in my situation, i used this free tool at iPhone SMS Database Merger for iOS 3.x and 4.x to merge my database to itself (i.e. used the same file for both). There were no duplicates, and it essentially re-wrote the database from scratch. As mentioned, group messages no longer appear as groups but as individual items, but ONLY for the group messages in the file. If you send a group message AFTER this process, it still does it, just the re-write merge process splits them up into individual conversations. (i can't see this being even a minute problem for anyone...can you??)

Once the process was complete, i immediately backed up to iTunes, and now I can now restore from iTunes to any iPhone (4.x and 5.x JB or non JB) and it's perfectly fine.

Obviously some people are having success with just dropping the old sms.db in, and that's good, but for anyone who's just, won't, work. Try the merger. I'm very happy that 4 years of SMS are still accessible by the phone.

No need to man, if you're having this problem, just turn off iCloud! :P

[Pr0ph3ts2]

1.Upon rebooting your iOS, don't open any app, especially the phone or contacts apps.
2. Copy into /var/mobile/addressbook your AddressBook.sqlitedb and AddressBookImages.sqlitedb using iFile (since your using it...) and set the permissions of "Owner" for both of the copied files to "mobile" if it's set as "root".
3. Respring

Hi codvisp,

I've followed carefully and exactly what you've mention. still no luck.
I'm running on ios 5. last updated from ios 4.3.3.

extracted AddressBook.sqlitedb from ios 4.3.3

jailbroken using redsn0w_win_0.9.10b3.

ssh into folders using ifunbox.

permission all set to "mobile"

tried a few permutations as follows:

1) as I do not have the folder "/var/mobile/addressbook", hence I created /addressbook folder and added in the 2 files. but alas, no sign of my old contacts.

2) tried copying AddressBook.sqlitedb and AddressBookImages.sqlitedb into addressbook that is found in /var/mobile/library/addressbook, respring, with apple loading screen, apparently, rebuilding the original files that have been overwritten.

3) tried deleting everything inside /var/mobile/library/addressbook, then copy the 2 old files into this folder, respring, no sign of my contacts.

4) using search, locate whatever /addressbook folder inside iphone, copy and paste the 2 old files into all the folders. still no sign of my contacts!!

I even went crazily googling and found this advise http://blog.lincomatic.com/?p=384, is it valid? as the date of the post seemed outdated given the fact that the current version of ios was released in november.


Should i do a clean restore and jailbreak, start all over again?
please help!!

[codvisp]

Hi codvisp,

I've followed carefully and exactly what you've mention. still no luck.
I'm running on ios 5. last updated from ios 4.3.3.

extracted AddressBook.sqlitedb from ios 4.3.3

jailbroken using redsn0w_win_0.9.10b3.

ssh into folders using ifunbox.

permission all set to "mobile"

tried a few permutations as follows:

1) as I do not have the folder "/var/mobile/addressbook", hence I created /addressbook folder and added in the 2 files. but alas, no sign of my old contacts.

2) tried copying AddressBook.sqlitedb and AddressBookImages.sqlitedb into addressbook that is found in /var/mobile/library/addressbook, respring, with apple loading screen, apparently, rebuilding the original files that have been overwritten.

3) tried deleting everything inside /var/mobile/library/addressbook, then copy the 2 old files into this folder, respring, no sign of my contacts.

4) using search, locate whatever /addressbook folder inside iphone, copy and paste the 2 old files into all the folders. still no sign of my contacts!!

I even went crazily googling and found this advise Lincomatic's Blog | electronics, hacking, etc, is it valid? as the date of the post seemed outdated given the fact that the current version of ios was released in november.


Should i do a clean restore and jailbreak, start all over again?
please help!!

The correct address is /Var/Mobile/Library/Addressbook and before you replace the files don't forget to TURN OFF iCloud...

[LHW]

No need to man, if you're having this problem, just turn off iCloud! :P

Hi codvisp,
I've been trying to solve the problem of missing SMSes using the methods you posted, but none of them helped.
I have an iPhone 3GS on iOS 5.0.0, jailbroken.
The problem started when i was trying to edit the sms.db using iFile, but I didn't save it though, I cancelled the changes. When I went back to the Messages app, all the messages disappeared.
I have tried your methods, other ppl's method but they all did not work. However, despite the fact that the messages are "missing" from the messages app, they can still be found when I used spotlight search.
btw, I have already turned off iCloud.

Do you know of any methods to help fix this problem?
Thx