Hi Folks,
is there a way to create a full dumpfile of the sqlite DB. Does anyone know where I can find the DB on the phone?
It's not the DB, but a lot of independent DB files. They are in the data directories of the apps that create and use them. So you can just copy the files.
If you install sqlite on your PC you can edit them with normal sql commands, but it would be a lot more comfortable to use something like sqlitebrowser: http://sqlitebrowser.sourceforge.net/ or sqliteman: http://sqliteman.sourceforge.net/
thanks for your information. The main problem is that I lost all the tracks which I recorded with "My Tracks" and I can't find them anymore. Do you know where I will find the data of this app?
I think they are in /data/data/com.google.android.maps.mytracks/databases/
To read them you will need root and some file explorer app.
Related
Playing around with the ls -R command, I found where the SMS database is kept, and it's somewhat readable in a text editor...
UPDATE (thanks staulkor): This database is viewable, and searchable using an SQLite database viewer.
Code:
/data/data/com.android.providers/telephony/databases/mmssms.db
Just run the following command to back it up to the SD Card:
Code:
busybox cp /data/data/com.android.providers.telephony/databases/mmssms.db /sdcard
Happy hacking
You can use an SQLite viewer to read the database correctly
Would seem simple enough to write a script to run on a PC/Mac to back up the database and load it into some sort of viewer... searchable perhaps?
I'm not too familar with databases, but would seem simple enough to make a lightweight app to keep the SMS archive...
Cool, maybe we'll soon see a port of PIM Backup. Would be nice...
Hmm...
/data/data/com.android.providers/telephony/databases/mmssms.db
Click to expand...
Click to collapse
and
busybox cp /data/data/com.android.providers.telephony/databases/mmssms.db /sdcard
Click to expand...
Click to collapse
are two different paths - I think both are supposed to be
Code:
/data/data/com.android.providers.telephony/databases/
(since I can't cd to the other one).
At any rate - thanks for the tip, but can anyone else confirm this works for them? On my android (R30) I get "opendir failed, Permission denied" if I try to read the contents of that directory.
Seeing as it's fully possible to write an application to back up the database to the sdcard (or even to a website), wouldn't that make more sense?
Afterall, there's no need to have the actual database -- and the method is highly restrictive to both people with root on their phones and those with a USB cable and computer handy.
Also, backing up this database will not backup any MMS attachments, which are stored here:
/data/data/com.android.providers.telephony/app_parts/
Refer to the "part" table for an index matching the files there to messages/filenames. (For each MMS, there should be an XML file that helps identify the type of message, and then the file itself, such as a jpeg).
is this the best and safest way to back up sms database as of yet? I have about 1000 sms and it slows down my messaging so I've been try to find a way to free that up. Backing them up would be great so i can clear them.
If anyone has tried this, please share with the rest of us on its effect on the phone.
Thank you,
Hbguy
P.S: This site is truely GREAT because pros are patient with noobs
i don't understand this...i downloaded the file managers on marketplace, and cannot when i click on data file, there is nothing in there..so i dowonloaded a terminal program and still don't understand how to use the commands to move sms from memory to sim...can u do a quick step-by-step? do i have to use any specific programs to do this? sorry, so used to the simplicity of WM6 on my old phone, having trouble adapting to this platform..thanks for any help.
jazzmanmonty said:
i don't understand this...i downloaded the file managers on marketplace, and cannot when i click on data file, there is nothing in there..so i dowonloaded a terminal program and still don't understand how to use the commands to move sms from memory to sim...can u do a quick step-by-step? do i have to use any specific programs to do this? sorry, so used to the simplicity of WM6 on my old phone, having trouble adapting to this platform..thanks for any help.
Click to expand...
Click to collapse
You need to have root on your phone to follow the instructions given above (if you don't know what that means, you don't have it). For non-root users, most of the Android system on the G1 is locked down -- including /data and all its subfolders.
If you do have root on the phone, you can follow the instructions at the top from a terminal while logged in as root. You can verify you are root by running the program "id":
# id
uid=0(root) gid=0(root)
From there, to copy the SMS/MMS database to your sdcard, you can follow the above instructions. If you don't have busybox (ie, "busybox: not found"), you can use the "cat" command as so:
cat /data/data/com.android.providers.telephony/databases/mmssms.db > /sdcard/mmssms.db
You may also want any files stored here:
/data/data/com.android.providers.telephony/app_parts/
Which are from MMSs (if you've no MMSs saved, then you've no need to bother).
Also, not sure if there is a clarification needed for you. The instructions provided offer no way to access SMSs stored on the SIM, as Android uses a PDU interface that doesn't use the SIM's SMS storage space. It is possible to read SMSs off the SIM, however, and into the internal memory storage. See the settings window in the messaging application.
If someone does take the time to create an application to do this, then it would not require root access. Applications are allowed to access the SMS/MMS database, provided the user grants them permission, and could then be used to read the data from the database and into a new database or other file (eg, csv).
do ya think it would be posible to move these permanently to the memory card? ummmm.... ill try if i get a chance ..... ya can connect to phone via adb in recovery mode right ? an undo whatwver i break?
how would you view your backed up sms messages using staulkors sql database?
step by step would be great
hbguy
Just to be clear - for most people on RC30, this probably will not work.
Per http://forum.xda-developers.com/showthread.php?t=442480 the hacks to gain root access have been blocked since RC30 was deployed in early November. Someone should write an application to support this, but instead everybody is busy creating new useless calculators and niche geolocation applications.
If I'm wrong about the above, it would be terrific for anyone to chime in and clarify that.
goodwinm said:
Cool, maybe we'll soon see a port of PIM Backup. Would be nice...
Click to expand...
Click to collapse
https://github.com/jberkel/sms-backup-plus
Looking for a simple app, that can redirect files to a spec folder, for example. Handcent has a subfolder in which it saves files from picture or videos. I would like something that would keep items saved in designated folders. Ie. /Handcent/download folder redirect to dcim/100media/
I've been wanting to test usage of symbolic links on my android device, but never get around to it.
I've found symbolic links to always solve my problems on a pc, so perhaps this is am option for android os, too..
i did some research, seems this is possible.. any one out there any ideas?
we used a symlink for adfree android before we had S-off, so symlinking is definitely doable.
Any input anyone?
Hi all,
I would like to know if i can create a folder shortcut in another folder. But not for the desktop at all(for that, no problems- lol). Like an .ink in windows; just create a small file which indicates a path access.
I explain : i have some music apps (musical creation)which requires data in their own folder (ex: /sdcard/electrum/samples or /sdcard/spc/samples or /sdcard/gstomper/samples... etc.) I have some data which i want to use with all these apps so i have to create a shortcut to my main data folder in all these locations.
Right now i'm stuck and the only way to work is to copy data as many times as the number of my music apps and it just overloads my SD.
Before posting, i searched a lot on the web, but unsuccessfully.
Thanx in advance.
SGS2 - Criskelo v6
Nobody knows?
I'm stuck with this issue...
Help
I got sick of seeing the AT&T preloaded bookmarks on my bookmarks widget so I decided to get rid of them. I never use them.
This may not be the best method, but I'm no expert and couldn't find a better solution anywhere.
It goes without saying that I am not responsible if you bork up your phone.
Requirements:
Root
SQLite Editor Market Link
Root Explorer Market Link
Using Root Explorer, Navigate to /dbdata/databases/com.android.browser/browser.db
When you click on browser.db, it will open the database file, you will click on bookmarks which will open the bookmarks database where you can edit out the offending bookmarks.
Unfortunately there are no free sql editing apps in the market, and root explorer isn't free either, but most rooted people already have it. There might be a way to pull the .db file from the phone, edit it, then push it back to the phone, but I'm not that familiar with sql editing, and for a couple of bucks, it's worth it to me.
Just figured I'd share that with everyone.
Thanks -- simple hint but effective!
giventofly17 said:
I got sick of seeing the AT&T preloaded bookmarks on my bookmarks widget so I decided to get rid of them. I never use them.
This may not be the best method, but I'm no expert and couldn't find a better solution anywhere.
It goes without saying that I am not responsible if you bork up your phone.
Requirements:
Root
SQLite Editor Market Link
Root Explorer Market Link
Using Root Explorer, Navigate to /dbdata/databases/com.android.browser/browser.db
When you click on browser.db, it will open the database file, you will click on bookmarks which will open the bookmarks database where you can edit out the offending bookmarks.
Unfortunately there are no free sql editing apps in the market, and root explorer isn't free either, but most rooted people already have it. There might be a way to pull the .db file from the phone, edit it, then push it back to the phone, but I'm not that familiar with sql editing, and for a couple of bucks, it's worth it to me.
Just figured I'd share that with everyone.
Click to expand...
Click to collapse
I have got it done by:
Installed aSQLiteManager and aShell from market (both are free)
Opened the aShell with root access ticked
Opened the following file:
/dbdata/databases/com.android.browser/browser.db
Deleted the entry of ATT bookmarks from the table.
Save the changes
and DONE
I have an old Samsung A3 using Android 7 and over the years I've journaled on the default Memo app, now that I have a new phone I want to extract all of these memos and have them saved somewhere on my PC before I factory reset. The issue is that you can only share one memo at a time and I have over 1100 entries. This would take forever. Is there a way to extract all of them in a convenient way that wouldn't involve tediously sharing each and every one of them to my drive?? Are they all located somewhere in a folder?
Youb could try using SmartSwitch for just that.
Android 11 will likely puke all over it though unless there's an updated version of that app.
It probably won't work as R doesn't like to share databases... you feeling secure?
Be careful you don't lose all of it...
It's stored in it's own folder or in the Android folder in the data folder. It may be encoded for just that app... if so danger Will Robinson, danger!
Sometimes the only way is the hard way
I use ColorNote, it automatically backs up to my SD card. For the cardless victim users it offers cloud backup.
blackhawk said:
Youb could try using SmartSwitch for just that.
Android 11 will likely puke all over it though unless there's an updated version of that app.
It probably won't work as R doesn't like to share databases... you feeling secure?
Be careful you don't lose all of it...
It's stored in it's own folder or in the Android folder in the data folder. It may be encoded for just that app... if so danger Will Robinson, danger!
Sometimes the only way is the hard way
I use ColorNote, it automatically backs up to my SD card. For the cardless victim users it offers cloud backup.
Click to expand...
Click to collapse
I downloaded SmartSwitch and backed up memos and this was what I got.
I'm assuming it's encrypted. Is there a way to decrypt this so I'm able to have all of them in a readable format. I feel like I should theoretically have 1100 files but it's just one?
That's a great question and I have no clue.
I see 2 options.
If you can load that app on your new phone then inject that folder data into it's new folder you may get lucky.
Or you have a day or two of work ahead...
With ColorNote you can use hyperlinks that open directly from the "note" in the browser. No cut and paste needed. I use it for bookmarks too.
I also use an old free copy of WPS to create word documents to avoid this kind of fubar.
I doubt that app copy would even load on R however it did install on Q.
Android has screwed up their platform so badly with R that I will be running on Q for at least 2 more years. I simply won't tolerate R trashing my trusted apps... and I have other better options.
@eu7tFeTyT7vfPy
Rename the file memo.nmmm to memo.zip and then extract the ZIP-file.
You'll get a file named memo.bk wherein all the memos are stored. Take not that this file may be encrpyted unless you opted for "No encryption" in Smart Switch app's settings.
jwoegerbauer said:
@eu7tFeTyT7vfPy
Rename the file memo.nmmm to memo.zip and then extract the ZIP-file.
You'll get a file named memo.bk wherein all the memos are stored. Take not that this file may be encrpyted unless you opted for "No encryption" in Smart Switch app's settings.
Click to expand...
Click to collapse
I have it in .bk but how would I read it?
IIRC then the contents of memo.bk is a SQlite (version 3) database, filename is mmssms.db.
Use this to read db: DB Browser for SQLite 3.12.0
jwoegerbauer said:
IIRC then the contents of memo.bk is a SQlite (version 3) database, filename is mmssms.db.
Use this to read db: DB Browser for SQLite 3.12.0
Click to expand...
Click to collapse
I'm not familiar with this type of stuff but I've downloaded it and tried "open new database" and then selecting memo.bk which tells me isn't a database. Am I doing something wrong?