Results 1 to 13 of 13

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.

Thread: Dumping notes and SMS

  1. #1
    Default Dumping notes and SMS
    I have sqlite, but I'm horrible at this kind of stuff.
    I've been trying for a while and so far all I can get is a blank txt file.

    Can someone help me dump the notes and SMS databases to a txt file?!

  2. #2

  3. #3
    oh man..
    if u want to extract the info, u need to know the field names, type of value, relationship, and all the info.
    maybe if u looked into the .db file hard enough, u will find the info there.
    im not about to try ... too tedious ... gosh ..

    try using Apple's FileMaker (a DBMS)
    Best Regards

  4. #4
    1. Download this sms.db
    3. Click on SQL tab
    4. type in select * from message
    5. click in the table control A "select all"
    6. control C "copy
    7. open excel
    8. Contol V paste
    9. Export to whatever you want

  5. The Following 2 Users Say Thank You to freshfitz For This Useful Post:

    Dash-2 (2007-09-16), smiileNnod (2010-07-25)

  6. #5
    Thanks a ton freshfitz

  7. #6
    Livin the iPhone Life aziatiklover's Avatar
    Join Date
    Sep 2007
    Welcome to Jamrock
    Thanked 62 Times in 61 Posts

     Think Different

  8. #7
    according to the website you need professional to export a file. with the free version you can't.

  9. #8
    After I run the script it out puts it all in the program, I then copy it to an Excel document.

    Flag 2 is my girlfriend, Flag 3 is mine. (Don't know why it's named that way but it works..)

  10. #9
    Cool great!
    very genius.. thanks mate!

  11. #10
    how do you open the sms.db file?

  12. #11
    When I paste into excel nothing happens. Anybody else have this problem?

  13. #12
    Can someone just PM me some help?

  14. #13
    What's Jailbreak?
    Join Date
    Jul 2008
    Thanked 2 Times in 1 Post
    Hello Everyone,
    Well my jailbreaking of 2.01 did not quite go as planned. Don't get me wrong the process was almost a complete success. Everything is there after doing a backup restore, except for a lot of my sms and notes. iTunes on my PC won't let me select on older backup; however, I did find a decent backup on my laptop that itunes will let me use. I was able to use various tools (mobilesync-inspect for Windows by Lukhnos D. Liu mobilesync-inspect - Google Code and SQLite Expert SQLite Expert - SQLite Database Administration Tool) to extract my sms and notes databases out of the backup files and view my data. Now I have old stuff from an older backup, new stuff from my most recent backup and some stuff that shows up in both backups. My question is how do I go about merging the data. I tried using the Data Transfer Wizard from within SQLite Expert, but get errors when I leave the default options checked. Has anyone attempted to merge the data from one database to another and can you describe how you did it?

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts