So do I have any way to view/extract a SQL DB from the phone? I can view the DB using a SQL editor/viewer on the phone for Workout Assist but the Export Data function isn't working from the app. The file that it creates isn't a known file type. If I could get the raw data, I could import it into SQL and write the query myself to pull the data I need but I can't figure out how to get the darn data off the phone.
Thanks
Like copying to the sdcard or what exactly?
hah2110 said:
So do I have any way to view/extract a SQL DB from the phone? I can view the DB using a SQL editor/viewer on the phone for Workout Assist but the Export Data function isn't working from the app. The file that it creates isn't a known file type. If I could get the raw data, I could import it into SQL and write the query myself to pull the data I need but I can't figure out how to get the darn data off the phone.
Thanks
Click to expand...
Click to collapse
why not back up the database, preferences etc (files)?
evilkorn said:
Like copying to the sdcard or what exactly?
Click to expand...
Click to collapse
I need the DB that is powering Workout Assist on my computer.
britoso said:
why not back up the database, preferences etc (files)?
Click to expand...
Click to collapse
How can I backup the DB and extract the file?
They are stored in /data/data/_package_name_/.
I still don't know what you mean, you said you can read the DB, which implies you know the location of the file.
evilkorn said:
They are stored in /data/data/_package_name_/.
I still don't know what you mean, you said you can read the DB, which implies you know the location of the file.
Click to expand...
Click to collapse
Yes... But how can I GET the DB files to import into SQL? If I try and attach it to an e-mail from Root Explorer, it looks like it attaches, but nothing is sent?
Just copy it to /sdcard/...
adb
lots of other options.
That is the same question I asked you and you just said you needed the db file.
evilkorn said:
Just copy it to /sdcard/...
adb
lots of other options.
That is the same question I asked you and you just said you needed the db file.
Click to expand...
Click to collapse
Ok... Sorry if I confused you. I got the file to my PC but it isn't readable by anything... Any ideas?
You can download sqlite3 for your pc and open the database with that.
mlevin said:
You can download sqlite3 for your pc and open the database with that.
Click to expand...
Click to collapse
Yep - thats what I did.... Had to export everything though to Access and query that way since SQLite doesn't export query results.
Thx
hah2110 said:
How can I backup the DB and extract the file?
Click to expand...
Click to collapse
the db IS a file. Simply backup by copyin gthe .db file, and when you need to restore it, push it back.
Related
Just a stupid Newb question. Not that it matters, but i'm just curious.
Where are the contacts saved on the tilt? is it like a csv file or what?
What if i just wanted to save just the file for the contacts externally without ActiveSync, is that possible?
MSanad said:
Just a stupid Newb question. Not that it matters, but i'm just curious.
Where are the contacts saved on the tilt? is it like a csv file or what?
What if i just wanted to save just the file for the contacts externally without ActiveSync, is that possible?
Click to expand...
Click to collapse
I think they are saved as a database file that cannot be copied over or copied from.
sherpa said:
I think they are saved as a database file that cannot be copied over or copied from.
Click to expand...
Click to collapse
Thanks for your reply
Your contacts are actually saved in the pim.vol file in the root of your device. Save that and you'll save your contacts.
this is for legal reasons. where exactly are sms messages stored? a lot depends on this!
I don't remember where exactly they are, but I think we have an app that can back them up. Even if you find them though they will be in a weird format
corp769 said:
this is for legal reasons. where exactly are sms messages stored? a lot depends on this!
Click to expand...
Click to collapse
Texts are stored in a database file located here in this directory:
Code:
/data/data/com.android.providers.telephony/databases
the name of the database file you want is called mmssms.db
To get it from your phone enter this code in terminal:
Code:
su
cp /data/data/com.android.providers.telephony/databases/mmssms.db /sdcard
That should copy the file to your sd card then you can mount your sd card and pull the file off to your PC. To read the file, download sqlite studio, install it, add the database and you should be able to figure it out from there. Sqlite studio can be found here
http://sqlitestudio.one.pl/index.rvt
(Deleted)
I didn't feel like plugging my phone into the computer so I emailed myself an apk file (arctu's Mms.apk) because for some reason...it seems to revert back to stock every reboot...
Anyway, I didn't have any terminal apps so I used Root Explorer to copy then paste over the existing apk. didn't work. Why not? Is there a something different about copy/paste?
If you didn't say you mounted the partition I can only assume it was not mounted as r/w and still at r/o.
copy/paste - visual representation of cp
push - pushing files from computer to phone
They are not the same.
SiNJiN76 said:
I didn't feel like plugging my phone into the computer so I emailed myself an apk file (arctu's Mms.apk) because for some reason...it seems to revert back to stock every reboot...
Anyway, I didn't have any terminal apps so I used Root Explorer to copy then paste over the existing apk. didn't work. Why not? Is there a something different about copy/paste?
Click to expand...
Click to collapse
Yeah, what didn't work? lol.
djmcnz said:
Yeah, what didn't work? lol.
Click to expand...
Click to collapse
the mms app didn't overwrite. But it could have been user error. I'm using Enom's ROM and didn't have the Community Mms Mod checked...so maybe if I had done that first...it would have worked.
Pushing is taking a file from the computer to copy and paste/overwrite the existing file on the phone. What's the difference where the file is being copied over from? Are you sure about what you were trying to explain?
SiNJiN76 said:
Are you sure about what you were trying to explain?
Click to expand...
Click to collapse
k?
I didn't try and explain anything (in this thread at least)?
Either way, yes push literally "pushes" a file to a specified location. However that file needs to be written and if the file system is mounted as read only you will get errors.
If it didn't work you must have received an error message (in root explorer for example), what was that message? If you don't get an error message and the file is still not being written then get a better file manager (ES File Explorer).
The suggestion above by 'evilkorn' was to make sure the file system is in read/write mode before you copy the file over... you can do this in Root Explorer or ES File Explorer.
If your file system is in r/w AND you still don't get an error message AND it still doesn't work then I would try an ADB push as a last resort and if that didn't work, reflash and start from step one I think...
SiNJiN76 said:
What's the difference where the file is being copied over from? Are you sure about what you were trying to explain?
Click to expand...
Click to collapse
Because that was your question in the title, which I answered, they are different terms for different things. You can't push a file on your phone to your phone, you copy it (cp).
You still didn't answer my question... It's hard to help someone when the suggestions fall on deaf ears and all you get is reverb and static back.
evilkorn said:
Because that was your question in the title, which I answered, they are different terms for different things. You can't push a file on your phone to your phone, you copy it (cp).
You still didn't answer my question... It's hard to help someone when the suggestions fall on deaf ears and all you get is reverb and static back.
Click to expand...
Click to collapse
LoL. You gotta ask a question first before I can answer it. You made assumptions, didn't ask questions. LoL. Anyway, I wasn't trying to crawl under your skin. But maybe next time you can read the OP in addition to just reading the title of the thread? Usually, details are given to accompany the title of the thread on the first post. Either way, I guess I wasn't detailed enough. Thanks for your feedback, tho, appreciate it.
@djmcnz - Sorry, my error in quoting the wrong person. Thanks for you explanation, also.
So, to summarize...Push and Copy/Paste should produce the same outcome, right? Cool...like I said earlier...it was my error in not knowing that I had to use the Spare Parts option in Enom's ROM to enable Community MMS.
I use root explorer all the time when I can't use a computer to use adb. It works fine. Usually if its the system partition you have to click the icon that says r/o and it changes to r/w. This will allow you to write files to the partition. Then from what I noticed a reboot usually fixes any issues of stuff not working.
Hi,
Just wondering if anyone has tried and tested the removal of bloatware apps from their Razr I XT890 running 4.12?
I'd be interested in cleaning the phone up a bit just to make it less crowded, I like to use real calc instead of stock calculator, go sms instead of stock messaging, zeam launcher instead of stock launcher etc etc.
I'm quite a novice when it comes to the technical side of things so would be too afraid to start deleting system apps incase they messed something up.
If anyone has seen a list compiled and could share, that would be great. Also, would it be Razr I specific, or would a general 4.12 safe removal list be safe to follow?
Any feedback appreciated
Here you can find answers.: http://forum.xda-developers.com/showthread.php?t=2223482
Read the forum.
Sent from my XT890.
Thanks a lot, have you any idea what to do with them zip files and how can I keep some of the google apps in the list? I'm not sure where to put the #?
cormie said:
Thanks a lot, have you any idea what to do with them zip files and how can I keep some of the google apps in the list? I'm not sure where to put the #?
Click to expand...
Click to collapse
I think that for you would be easier use Titanium Backup or SystemAppRemover (need root acces) to remove apps.
If you want use the zip file you have to unlock bootloader and flash CWM. In CWM you can install zip files. # you must put in front of the line where is written desired app. Updater-script you can fing in the zip file /META-INF/com/google/android/
Thanks again, I actually have my phone rooted and was able to apply the debloater, however I don't want to remove everything so will restore the backup I took before trying it, I tried install the zip file with the edited script (with the # in front of the ones I wanted to keep) but it failed to install via recovery so I must be doing it wrong
I extracted the script file, opened with wordpad, edited, closed and saved, put it uncompressed back into the zip and tried it.
that failed, so I tried open directly from the zip, edit, close and save and flash that too but that failed too the original unedited one doesn't fail.
The error I get is something referring to error in zip file.
cormie said:
I extracted the script file, opened with wordpad, edited
Click to expand...
Click to collapse
Do not use WordPad. Edify scripts require line endings to be linux style (LF only). Wordpad converts them to windows style (CR LF). Use another editor; I recommend notepad2-mod (set syntax highlighting, F12, to shell script)
See I edited and saved in wordpad and wasn't prompted to save in any other format, do you think it still saved in CR LF?
In the same script and another edit, I think I pasted something from somewhere else and went to save, but then it prompted me to save in the wordpad format itself (rtf I think it was) which I didn't, when I simply added a # or two, it just prompted to save without asking for format so it appeared to save as it was and not change anything? So you reckon it still changed it to the non-readable CRLF?
Would basic windows notepad be ok to edit it instead of having to download notepad 2?
Thanks for tyour help so far!
Maybe I'd be better just doing this via root explorer, of which I have some experience of. Is it just a case of locating each of the files listed in the script and deleting them or is there other hidden crap elsewhere that the script gets rid of which a simple root explorer delete won't?
cormie said:
See I edited and saved in wordpad and wasn't prompted to save in any other format, do you think it still saved in CR LF?
In the same script and another edit, I think I pasted something from somewhere else and went to save, but then it prompted me to save in the wordpad format itself (rtf I think it was) which I didn't, when I simply added a # or two, it just prompted to save without asking for format so it appeared to save as it was and not change anything? So you reckon it still changed it to the non-readable CRLF?
Would basic windows notepad be ok to edit it instead of having to download notepad 2?
Thanks for tyour help so far!
Click to expand...
Click to collapse
Try notepad++
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?