Can notes.db be opened on a PC or firmware 2.0?

[mdavenport]

I just upgraded my (1st gen) iphone to firmware 2.0. Before I done this I took a copy of the notes.db file from var/Mobile/Library/Notes.

I also did a backup using iTunes but the restore is failing.

I have copied the notes.db back to my iphone using ssh but they are not being displayed. Also if I try to add a new note then it doesn't get saved. It is like the new firmware stores them in a different format.

If I go back to the default notes.db I can then create/delete/modify notes ok.

Is there a way to open the notes.db on a PC to extract the data and allow me to copy these into an a text file so I can re-enter them manually?

Thanks
Mark

[sunnylam2000]

I copied notes.db file to var/Mobile/Library/Notes on iphone to restore my old notes and it works for me.

You need to make sure the permission is set to 644 (or above) and the owner is "mobile:mobile". I think when you overwrite the existing one, you will get the right permission and owner settings.

Hope it helps.