Related
hey. i'm looking for a program (preferably freeware) that is able to list all your contact names and numbers to a text file? I'm familiar with the PIM Backup program, but it does allow u to open the backup file in a word processing folder with all the information.
thanks.
Hey guys
Is there any PC applications for windows ors Linux that can save or backup SMS txt messages from my nexus one.
It's a forensics assignment and I was thinking of checking out android.
Any help would be awesome ^_^
You just have to pull the file from the phone using the tools in the SDK. adb pull and adb push the file back after you wipe.
http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=where+are+android+sms's+stored
the things to back up are:
/data/data/com.android.providers.telephony/databases/mmssms.db
/data/data/com.android.providers.telephony/app_parts/*
(app_parts contains any sms attachments. if you were to try to open a text with a picture in it and the appropriate app_parts/* was not there it would force close).
when restoring, if restoring to a fresh rom, you have to create the app_parts folder (as it does not initially exist -- it is created when the first mms is sent or received) and then put all of the files into it. also move the mmssms.db back to its original location. and make sure you set the permissions, owner and group back to the what they were when you pulled them.
you can open the mmssms.db with a sqlite database viewer.
Hey guys thanks so much ^_^ really appreciate it.
Would I need to root my phone in order to pull these DB files?
Probably, but maybe not... I can't test because I have always rooted.
to pull those files, maybe not. to push those files, probably yes.
try it
Code:
c:\android\tools>adb pull /data/data/com.android.providers.telephony/databases/mmssms.db c:\
failed to copy '/data/data/com.android.providers.telephony/databases/mmssms.db' to 'c:\/mmssms.db': Permission denied
c:\android\tools>
Thats the error that I get when I try it ... even if I tried doing ls -l /data/, I get this:
Code:
c:\android\tools>adb shell ls -l /data
opendir failed, Permission denied
c:\android\tools>
I just need to create a demonstration, could someone clean their txts messages DB and then get someone to send some messages, in order for me to show it to class, what would happen, if my droid was rooted.
I know there's an app called SMS Backup which basically reads this and dumps HTML output to email or screen but thats modifying the phone, which i will not have to do.
Or just use SMS Backup and Restore from the Market. It'll back up your SMS to an XML file on your SD which you can then transfer to your PC. Much easier. It just doesn't do MMS.
That's not forensic enough. If I ran adb root to restart in root mode, would that root it enough to void the warranty?
You could use MyBackup Pro. Once sms/mms's are backed up, they are in a zip file in the rerware folder of your SD card.
sigh >.< it seems that I cant forensically image /data/data/com.android.providers.telephony/databases/mmssms.db
so sad.. Need a rooted phone.
Hi all!
This in my first thread in this forum
As in the title, I'd like to ask you if there's a way to merge mmssms.db files in a single file. I do a lot of backups and programs like MyBackup overwrite them everytime, furthermore I can't let other people to read them. I don't think is impossibile, in fact there's a script to merge iPhone's sms. Thanks a lot in advance!!
Nobody can help me?
the mmssms.db is a SQLite Database. Google for "merge SQLite databases" and
you will find some results. It seems to be possible, although I can't tell you exactly
how to do it, because I don't know anything about SQLite databases.
But I can imagine opening one database and then copy the content of the other
databases and attach it to the first one should be a possible solution.
I've already googled, and found anything good. I can't edit an SQL database via command line (SQLite is almost textual), and most little graphical editors are very limited. That's because I decided to write here
Looking for the same. How to compile mmssms.db files?
I'm trying to do the same thing has anyone found a decent solution?
SMS Backup & Restore lets me save it as XML on the sd card, then restore nandroid to a rom with other SMS and use SMS Backup again there, it adds to the existing XML file on your sd card.. so that would work, but I was hoping for something quicker than having to restore 6 different nandroids run a program and then go back.
I feel like there must be a way to just add the contents of one mmssms.db to another but not sure what software would allow me to do that.
I have extracted 6 different mmssms.db files from my nandroid backups and have them sitting in a folder now.... hmm what next
Found an Online solution?
I found an online solution: https://smsmerge.homedns.org/
The PHP source is here: https://smsmerge.homedns.org/?source=1
I haven't tried it because I'm not a fan of online tools for such personal data so I am waiting for an offline solution.
Ideas:
-Maybe an APK that can seek out *.db files and merge them, possibly seeking out NANDROID backups.
-Otherwise a bash script will do too.
Anyone want to take a swing at this?
I'm willing to collaborate
I know it's been a couple of months,
but has a solution been found???
i use sqlitespy to merge my htc sense mmssms.db file with cm mmssms.db file
first open the new db file (in my case cm file)
then open the old db file with file>attach database
then if your case is same with me you can use the sql script below to insert your db file to the new one (my case old file:leedroid 3.3 htc sense new file cm10.1 vj mod)
if your case is different you have to edit the sql script in order to match the tables columns in each file (a little sql knowledge needed)
Code:
insert into main.sms(_id,thread_id,address,person,date,protocol,read,status,type,reply_path_present,subject,body,service_center,locked,error_code,seen) SELECT _id,thread_id,address,person,date,protocol,read,status,type,reply_path_present,subject,body,service_center,locked,error_code,seen FROM mmssms.sms;
insert into main.addr select * from mmssms.addr;
insert into main.canonical_addresses select * from mmssms.canonical_addresses;
insert into main.part select _id,mid,seq,ct,name,chset,cd,fn,cid,cl,ctt_s,ctt_t,_data,text from mmssms.part;
insert into main.pdu (_id,thread_id,date,msg_box,read,m_id,sub,sub_cs,ct_t,ct_l,exp,m_cls,m_type,v,m_size,pri,rr,rpt_a,resp_st,st,tr_id,retr_st,retr_txt,retr_txt_cs,read_status,ct_cls,resp_txt,d_tm,d_rpt,locked,seen) select _id,thread_id,date,msg_box,read,m_id,sub,sub_cs,ct_t,ct_l,exp,m_cls,m_type,v,m_size,pri,rr,rpt_a,resp_st,st,tr_id,retr_st,retr_txt,retr_txt_cs,read_status,ct_cls,resp_txt,d_tm,d_rpt,locked,seen from mmssms.pdu;
insert into main.threads (_id,date,message_count,recipient_ids,snippet,snippet_cs,read,type,error,has_attachment) select _id,date,message_count,recipient_ids,snippet,snippet_cs,read,type,error,has_attachment from mmssms.threads;
insert into main.words select * from mmssms.words;
hope this helps others that forget to backup sms using a third party app.
Hi, I’m having a problem with the HTC Notes App on my Rogers HTC One. I have backed up a copy of the folder ".data\HtcNotes" on the SD card, thinking that this folder contains all my notes files. I then wiped my phone and started setup as a new phone. I tried restoring my backed up notes by replacing the folder ".data\HtcNotes" with the one I had backed up earlier but the Notes App does not recognize the restored files. the Notes App works fine, i.e I can create new notes without any problems.
Also, when I try to open the "contentE.html" stored for each note inside subfolders of ".data\HtcNotes", I get unreadable characters. This happens for my new and properly functioning notes as well. Does the Notes App store content in a non-standard html format?. It used to be that the Notes app stored the content in a file called "content.html" which was a normally readable html format, but now it stores in the non-readable " "contentE.html" file.
Please advise how to recover the content of my notes...is there a way I can open the "contentE.html" files in a readable format?. My notes are not synched to the clouds and are stored only locally on the phone.
Thanks
any suggestions?
dabasdabas said:
any suggestions?
Click to expand...
Click to collapse
you may have to reset the permissions of the files
you do this with ES File Explorer and highlight a file go to properties and set the permissions ... usually to rw-r-r but notes files may be different check one you just created and make the old ones the same
thanks for the suggestion, I am able to open the "contentE.html" of my old notes using an html editor or browser, but the file contains unreadable characters, as if I'm opening a binary file inside a text editor. The same thing happens for any new notes I create.
I remember in earlier versions of Android, the Notes app used to store the content in a file called "content.html" which was a normally readable html format, but now it stores it in a "contentE.html" file which is not readable by html editors...
attached is an example of the "contentE.html" file from a new note I've just created, it's supposed to be titled "w1" and contain only the word hello...if you try to open it you'll understand what I'm trying to describe...can you guys please check the "contentE.html" on your phone and let me know if you're able to open the file properly outside the Notes app...thanks...
guys need your help...can anyone please check the "contentE.html" located in numeric subfolders under ".data\HtcNotes" on the SD card and let me know if you're able to open the file properly outside the Notes app...thanks...
bump
i use colornote app, its free in playstore, you can sync with gmail,.. if you use another android phone just install same app, and your note will there to
BUMP!!
Having the same problem, did a factory reset of my phone and the files arer physically still intact, but I can't open them with Evernote app or HTC Notes app. Alle notes are stored in a folder with a .PNG and a .HTML file, the HTML file contains unreadable text. There's very important info in for me, which I need within a week. Can someone please help? I'm willing to do almost anything to be able to read my files...
Still unsolved (bump)
mpc007 said:
Still unsolved (bump)
Click to expand...
Click to collapse
^^
mpc007 said:
^^
Click to expand...
Click to collapse
This disappoints me. If you consider yourselves even moderately skilled, this little problem of my should be peanuts.
Please, help me how to restore my notes from the ContentE.html file!!
mpc007 said:
This disappoints me. If you consider yourselves even moderately skilled, this little problem of my should be peanuts.
Please, help me how to restore my notes from the ContentE.html file!!
Click to expand...
Click to collapse
Try this, create a new note in the HTC Notes app and save it (If it doesn't save, just write random words and exit, it should save then), then go to your .data/HtcNotes folder, find the folder that contains the note you just created. There should be an existing "ContentE.html" file. Delete it and replace it with the file you want to restore.
mpc007 said:
This disappoints me. If you consider yourselves even moderately skilled, this little problem of my should be peanuts.
Please, help me how to restore my notes from the ContentE.html file!!
Click to expand...
Click to collapse
I think you're wasting your time, just having the ContentIE.hml file won't be enough, the actual database is stored in /data/data/com.htc.notes (i think), and without that, the app can't link to the contents of the sdcard.
nkk71 said:
I think you're wasting your time, just having the ContentIE.hml file won't be enough, the actual database is stored in /data/data/com.htc.notes (i think), and without that, the app can't link to the contents of the sdcard.
Click to expand...
Click to collapse
My data folder is indeed empty. However, can't it just be enough to have the raw files from the .data/htcnotes/ folder? I have those, every note exists of a folder with a PNG and a HTML file. They're just not recognised by the Notes App.
mpc007 said:
My data folder is indeed empty. However, can't it just be enough to have the raw files from the .data/htcnotes/ folder? I have those, every note exists of a folder with a PNG and a HTML file. They're just not recognised by the Notes App.
Click to expand...
Click to collapse
Yes, but unless i'm mistaken, the Notes app will rely on the database file, which in turn would link to the contents on the sdcard... so even if the contents weren't on the sdcard they would still show up in the notes app, but not vice versa.
And I don't know of any way to reconstruct the database file.... maybe try searching for that.
nkk71 said:
Yes, but unless i'm mistaken, the Notes app will rely on the database file, which in turn would link to the contents on the sdcard... so even if the contents weren't on the sdcard they would still show up in the notes app, but not vice versa.
And I don't know of any way to reconstruct the database file.... maybe try searching for that.
Click to expand...
Click to collapse
Nobody found a way yet? right?
If you have a backup of your data (or data partition), you need to restore the contents of /data/data/com.htc.provider.notes (as well as com.htc.notes, i think) and set the file permissions by ES file explorer or sth. This is tested and works (I got this answer off google somewhere else, but since this xda thread is the first result that comes up for searches like "recover htc notes", I (necro-)posted the solution here).
Now comes the hard part: If you don't have backup of com.htc.provider.notes, here's how I suggest you hack it BUT I haven't tested: try adding a new note in an empty instance of the notes app. The file /data/data/com.htc.provider.notes/databases/notes.db will be an SQLite file. Open it with any SQLite editor on your computer and you see IDs and file names in its tables match with the created note in your /sdcard/.data/HtcNotes folder. See if you can modify the notes.db database by adding new rows in all related tables to make the app recognize your old HtcNotes files. Don't forget to change file permissions of notes.db after restoring it to your device (I gave rwx-rwx-rwx to everything I copied). If you're lucky and knowledgeable enough you might be able to fix it.
Lesson to learn: Sync, or use plain-text file next time for writing notes.
Chromatix said:
Now comes the hard part: If you don't have backup of com.htc.provider.notes, here's how I suggest you hack it BUT I haven't tested: try adding a new note in an empty instance of the notes app. The file /data/data/com.htc.provider.notes/databases/notes.db will be an SQLite file. Open it with any SQLite editor on your computer and you see IDs and file names in its tables match with the created note in your /sdcard/.data/HtcNotes folder. See if you can modify the notes.db database by adding new rows in all related tables to make the app recognize your old HtcNotes files. Don't forget to change file permissions of notes.db after restoring it to your device (I gave rwx-rwx-rwx to everything I copied). If you're lucky and knowledgeable enough you might be able to fix it.
Click to expand...
Click to collapse
I have a HTC Sensation and I used the HTC Notes app often and so does my girlfriend on her Sensation. I recently changed ROMS on both our phones and have been trying to figure out how the hell to restore our notes. You indeed need to edit that notes.db as you mentioned. I know you didn't test it, but I just tried your suggestion and it did work on my first try. :victory: Here's what I did:
1) I opened the HTC Notes app and created a new note and named it Blah and saved it.
2) I used ES File Explorer to navigate to /data/data/com.htc.provider.notes. Then I copied the notes.db file to my microsd card.
3) I used DB Browser for SQLite to open the notes.db files that I copied to the card. Then clicked on the tab that says Browse Data, then in the drop down menu where it lets you pick a table, I choose notes. There you can see what notes the HTC Notes app will recognize.
4) The note I created earlier called Blah was on row 2, so I clicked on New Record and carefully made a new entry in row 3 with the same format as row 2. Just VERY carefully edit the columns that say: notebook_id, name, data, saved_time, last_modified_time, saving_time, ap_extra_info, thumdnail_path, widget_screenshot_path, and HTC_CREATED.
5) Verify the info you entered is correct fore ach column, then write changes to the database (File menu, Write Changes.)
6) I copied my now modified notes.db from my sdcard back to /data/data/com.htc.provider.notes ES File Explorer, changed the permissions of the file to match notes.db-journal,
7) And finally, I restarted the HTC Notes app, and the new note I added to the database was recognized.
I can think of a shorter way of doing this, but I''ll have to test it first. :fingers-crossed: Why did HTC have to complicate this? Why can't the app just read the files that are in the same folder or provide a refresh option to read any new files that may have been added to .data\HtcNotes at the very least?
Is there anyway to possible open this backup file with a program. I no longer have an htc phone, but I would like to retrieve some old contacts and sms messages. When I open the folder, the files have no association, it just says file. They are are also oddly names like "1a0c21af-b4f3-4927-bae2-e05fadbd901b". Any help would be greatly appreciated. Thanks in advance
Cooltownaz said:
Is there anyway to possible open this backup file with a program. I no longer have an htc phone, but I would like to retrieve some old contacts and sms messages. When I open the folder, the files have no association, it just says file. They are are also oddly names like "1a0c21af-b4f3-4927-bae2-e05fadbd901b". Any help would be greatly appreciated. Thanks in advance
Click to expand...
Click to collapse
This is really complicated if you dont have access to a HTC device anymore. But there is a way if you are able to do that or you know someone who can... http://blog.interrupt3h.com/?p=328 What is written on this page is for restoring mp3 files out of the HTC backup, but it should work for every file. Just read it