Viewing notes.sqlite or .sq file from iTunes backup.

Discussion in 'iPhone Tips, Help and Troubleshooting' started by Hummer, Feb 20, 2011.

  1. Hummer, Feb 20, 2011
    Last edited: Feb 20, 2011

    Hummer macrumors 65816


    Feb 3, 2006
    Queens, New York NY-5
    I've spent the majority of my day trying to view the notes from my iPhone backup that has the extension .sqlite, however when I open the file in text edit, I can see some readable text, but there is no order. Also, when I open it in an SQlite editor, I just get a bunch of tables that I don't know what to do with.

    So could anyone help me out in the proper way to extract these lost notes from my backup file?

    Edit: I figured it out and was able to convert the HTML as well. If anyone stumbles across this post on the web, as I have stumbled upon many abandoned threads while searching for a solution, I'd be glad to help them out. Send me a Private Message.
  2. robawalsg macrumors newbie

    May 4, 2011
    i also am trying to read the sqlite file
    how did you do this, without having to sift through and delete all the unwanted text?

    please email:
  3. crispinb macrumors newbie

    Jul 12, 2011

    I would also really appreciate some more details on this matter ... upgraded to IOS 5 beta 3 and this is the ONLY issue which has caused me a problem... I have lost 3+ years worth of notes and need to get them back from an old backup! (

    If you can provide any guidance that would be greatly appreciated!

    Many thanks :)
  4. ShamTech macrumors newbie

    Jul 13, 2011
    Hey I'd also like to know the answer to this question. But having since just registered today I can't private message you, yet. Or is that even enabled on this forum? Either way I didn't see an option to private message.
  5. testcard macrumors 68030


    Apr 13, 2009
    Northumbria, UK
    From Forum FAQ/Rules:

    Why can't I send a Private Message?

    You may not be eligible to use this feature yet.

    Before you can send a Private Message or email to another forum member, these conditions must apply:

    You must have a post count of at least 5, as shown in your user profile.
    You must have been a forum member at least one day.
    The recipient must have enabled receipt of Private Messages or email in their User Options. The options are named Enable Private Messaging and Receive Email from Other Members.
  6. ponnalaraj macrumors newbie

    Oct 8, 2012
    Need Help: Saving the sqlite file from an app to system via itunes

    i am trying to save my "SQLITE" file from my app to system via iTunes. how can i do that.please help me regarding this issue.


Share This Page