solved: How to access Notes in iTunes backup?

Discussion in 'iPhone Tips, Help and Troubleshooting' started by Reach9, Mar 2, 2013.

  1. Reach9, Mar 2, 2013
    Last edited: Mar 2, 2013

    Reach9 macrumors 68020

    Reach9

    Joined:
    Aug 17, 2010
    Location:
    In America
    #1
    So i completely forgot to back up my notes on my iPhone before doing a recent Factory Restore.

    Luckily i was able to access the notes.sqlite file through the iPhone Backup Extractor for Mac. I'm able to save the file as a CSV but i'm having an issue..

    I'm only seeing the first line of the notes in the backup on FireFox's SQLite Manager. Is there anyway i can read the entire thing? thanks

    did i use the right string? i used: SELECT ztitle, zauthor, zsummary FROM znote

    ----

    problem solved i used MesaSQlite to get the entire note, not FireFox's SQLite Manager
     
  2. ipsychedelic macrumors 6502a

    ipsychedelic

    Joined:
    Mar 8, 2012
    #2
    Just for reference, there is also a (free) great SQLite manager in the AppStore, called Liya.
     

Share This Page