How to get sqlite database with adb commands?

Question

0.00/5 (No votes)

See more:

A few months ago, I've developed a windows application to get my android application sqlite database with this adb command : adb exec-out run-as mypackagename cat /databases/mydbname.db > myPCaddress(D:\mydbname.db)

It was working correctly but after a while when I want to test it again, the command copy a file in the PC, which has 1kb size and not even a database file! I'm so confused and I don't know what is the problem.Please help me.

What I have tried:

I've tried using : adb -d shell "run-as mypackagename cat /data/data/mypackagename/databases/mydbname.db" > myPCaddress (D:\mydbname.db)
and I've got same result and with adb pull, it shows remote permission denied.

Posted 20-May-18 21:28pm

marimir

Add a Solution

Comments

Richard MacCutchan 21-May-18 3:54am

Your question is not clear. What is the Windows application doing in this situation?

marimir 21-May-18 4:06am

windows application run adb command :adb exec-out run-as mypackagename cat /databases/mydbname.db > myPCaddress(D:\mydbname.db)

Richard MacCutchan 21-May-18 4:07am

Please edit your question, show the code that has the problem, and what results you see.

marimir 21-May-18 4:29am

forget about the question..
I want to copy my android application database to my PC with adb command. I've opened cmd.exe and navigate to adb folder. After executing this command ==> "adb exec-out run-as mypackagename cat /databases/mydbname.db > myPCaddress(D:\mydbname.db)" the copied file size in my PC is 1kb and it is not a sqlite database file. This is my problem.

Richard MacCutchan 21-May-18 4:44am

You should use "adb pull", which will do a proper binary copy. The cat command is for text files.

marimir 21-May-18 4:54am

I've tested ==>"adb pull /data/data/mypackagename/databases/mydbname.db myPCaddress(D:\mydbname.db)" but I get "remote Permission denied"

Richard MacCutchan 21-May-18 4:58am

Use "adb shell run-as" with your package name to get access to the private space. You can then use the pull command within the shell.

marimir 21-May-18 5:20am

I've tested ==> "adb shell run-as mypackagename" and I get "Could not set capabilities: Operation not permitted"

Richard MacCutchan 21-May-18 5:25am

Did you give the full package name? In my case it is "adb shell run-as com.utils.cardapp".

marimir 21-May-18 5:36am

I don't have a rooted device so I don't have permission.

Richard MacCutchan 21-May-18 5:43am

My device is not rooted (as far as I am aware) but it does have a debug feature which allows me to do this. If it is an issue with the device then there is nothing much we can do to help.

marimir 21-May-18 5:53am

you mean usb debugging by debug feature?

Richard MacCutchan 21-May-18 5:55am

Yes, that works on my phone.

marimir 21-May-18 6:12am

ok thank you for your response.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)