Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.
Thread: Dumping notes and SMS
09-09-2007, 10:36 PM #1
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?!
09-15-2007, 11:35 PM #2
09-16-2007, 05:09 AM #3
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
09-16-2007, 08:03 AM #4
1. Download this http://www.sqliteexpert.com/download.html
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
09-16-2007, 02:20 PM #5
Thanks a ton freshfitz
10-04-2007, 10:44 PM #6
nice Think Different
10-05-2007, 12:13 AM #7
10-05-2007, 12:53 AM #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..)
02-07-2008, 08:38 AM #9great!
very genius.. thanks mate!
06-14-2008, 02:42 PM #10
how do you open the sms.db file?
07-11-2008, 01:34 PM #11
When I paste into excel nothing happens. Anybody else have this problem?
07-18-2008, 04:29 AM #12
Can someone just PM me some help?
08-15-2008, 09:16 AM #13
- Join Date
- Jul 2008
- Thanked 2 Times in 1 Post
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?