How do I pull the sqlite database from the android device?

Question

How do I pull the sqlite database from the android device like emulator?

This will be the latest answer https://stackoverflow.com/a/51587416/5257674 — Waqas Ahmed, Sep 21 '18 at 06:46

Manmohan Soni · Answer 1 · 2017-04-25T14:09:47.043

57

You can use these commands for pulling the data base from your device. Typing these commands through android studio is very easy. Please make sure you have set the path of adb globally to your system. Then open the "terminal" window from bottom to android studio and near to "Android Monitor". Now you just update the following commands with actual package name of your app and database file name. You will get your file out from the device.

adb shell "run-as package.name chmod 666 /data/data/package.name/databases/file"
adb pull /data/data/package.name/databases/file .
adb shell "run-as package.name chmod 600 /data/data/package.name/databases/file"

the command for Android 5.0+ /data/data/package.name/databases/file would be:

adb shell "run-as package.name chmod 666 /data/data/package.name/databases/file"
adb exec-out run-as package.name cat databases/file > newOutFileName
adb shell "run-as package.name chmod 600 /data/data/package.name/databases/file"

edited Apr 25 '17 at 14:09

answered Aug 29 '14 at 10:33

Manmohan Soni

6,472
2
23
29

Perfect. If you want to inspect the data folder first, have a look at this post: http://stackoverflow.com/questions/9017073/is-it-possible-to-see-application-data-from-adb-shell-the-same-way-i-see-it-moun – shadowhorst Jun 26 '15 at 18:04
It always gives me file with 0 bytes ?? – Rajeev Kumar Apr 17 '17 at 06:47
@Rajeev Kumar -I have update the answer for devices with version greater than Lolipop. One more thing I want to address is that this commonds generally does not works for Samsumg devices. May be samsung devices have some restrictions or issues Please take care before use. – Manmohan Soni Apr 25 '17 at 14:05

score 9 · Answer 2 · edited Mar 09 '18 at 14:46

9

You can use Android Device Monitor to pull it. Go to Tools -> Android -> Android Device Monitor

Select your device from the left list.
Select FileExplorer tab
Expand data-> data -> "yourpackageName" -> databases
Select your databaseFile and on the top right click on this icon pull a file form a device.
Save it on your desk then use this tool to open it: http://sqlitebrowser.org/

edited Mar 09 '18 at 14:46

leonardkraemer

6,573
1
31
54

answered Nov 22 '17 at 15:07

Moaz Rashad

1,035
1
10
16

score 6 · Answer 3 · edited May 23 '17 at 11:47

6

connect your device to pc
open command prompt in /sdk-directory/tools
type adb pull /data/data/com.example.app/databases/database.db

where com.example.app is your application package name and database.db is the database file

that's in case your device is rooted, if not try following

https://stackoverflow.com/a/8433520/1300995

edited May 23 '17 at 11:47

Community

1
1

answered Jul 22 '12 at 06:38

biegleux

13,179
11
45
52

this worked but the pulled file does not show any tables. – Andrain Dec 02 '15 at 04:27
Same issue where pull not showing any tables. I know this is old but any solution for this? – cvb May 10 '19 at 18:38

score 6 · Answer 4 · answered Feb 16 '18 at 12:39

from version 24 onwards i use these commands to pull database

adb shell
run-as package.name
cat /databases/database.db > /sdcard/database.db
exit
exit
adb pull /sdcard/database.db

prior to version 24

adb pull /data/data/package name/databases/database.db

was sufficient

score 5 · Answer 5 · answered Oct 02 '14 at 19:39

The best way to view and manage you android app database is to use this library https://github.com/sanathp/DatabaseManager_For_Android

Its a single java activity file ,just add the java file to your source folder you can view the tables in your app database , update ,delete, insert rows to you table .Everything from your app.

When the development is done remove the java file from your src folder thats it .

It helped me a lot .Hope it helps you too .

You can view the 1 minute demo here : http://youtu.be/P5vpaGoBlBY

score 5 · Answer 6 · answered Nov 08 '17 at 21:31

5

You can skip all those middle stages with one command.

In your PC shell run:

adb -d shell 'run-as <package_name> cat /data/data/<package_name>/databases/<db_name>' > <local_file_name>

answered Nov 08 '17 at 21:31

Emre

125
1
2
3

score 3 · Answer 7 · answered Jun 28 '16 at 06:02

3

adb root
adb remount
adb pull <remote>  <local>

answered Jun 28 '16 at 06:02

Logic Luo

31
2

score 3 · Answer 8 · edited Sep 09 '18 at 07:22

I know this is an old question, however this is what I did to pull the SQLite Database file from app on device.

Saving the file from app package to device sdcard

adb -d shell "run-as com.dautechnology.abdimuna.smartparking cat /data/data/<myAppPackageName>/databases/<databaseFileName> > /sdcard/<databaseFileName>"

The above command will store file to /sdcard You can verify the file by adb shell ls sdcard/ Then exit from adb shell by typing exit

Pull the file from sdcard to your current working location.

adb pull sdcard/<databaseFileName>

Move the file to Desktop or place of your desire.

mv <databseFileName> ~/Desktop

I hope this helps someone out there.

score 2 · Answer 9 · edited Nov 09 '17 at 00:23

Do it programatically in application

try {
    File file = Environment.getExternalStorageDirectory();
    File data = Environment.getDataDirectory();

    if (file.canWrite()) {
        String currentPath = "/data/data/" + getPackageName() + "/databases/yourdbname";
        String copyPath = "copydb_name.db";
        File currentDB = new File(currentPath);
        File backupDB = new File(file, copyPath);

        if (currentDB.exists()) {
            FileChannel src = new FileInputStream(currentDB).getChannel();
            FileChannel dst = new FileOutputStream(backupDB).getChannel();
            dst.transferFrom(src, 0, src.size());
            src.close();
            dst.close();
        }
    }
} catch (Exception e) {

}

Make sure given permission

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>

Does it require root access? – Angad Singh May 28 '18 at 09:56 — Angad Singh, May 28 '18 at 09:56
As far as I know, root permission is not required. – SARATH V May 30 '18 at 06:54 — SARATH V, May 30 '18 at 06:54

score 1 · Answer 10 · answered Jul 22 '12 at 07:25

1

If you use eclipse then go to DDMS view . from File Explorer Tab ->data->data->application package name->databases-> databse name

select database db file then click pull button

answered Jul 22 '12 at 07:25

Mohammod Hossain

4,134
2
26
37

At normal device you cannot even open data folder. – Nov 19 '14 at 00:53
it's depends on your device. – Mohammod Hossain Jan 06 '15 at 03:33

How do I pull the sqlite database from the android device?

10 Answers10

Linked