Unable to View or pull SQLite database from device

Question

I am unable to View or Pull my SQLite database file created by my application on my device.

Here is how I tried to pull it using ADB

E:\>adb pull /data/data/com.example.testinglist/databases/timetracker.db failed to copy '/data/data/com.example.testinglist/databases/timetracker.db' to './timetracker.db': **Permission denied**

As you can see there is a Permission denied error.

I can't see or copy file using FileExplorer in Eclipse ADT. Only folder data can be copied as unable to move in the folder in FileExplorer. and folder Data copied to computer using FileExplorer is empty. Any solutions please?? enter image description here

If you try to pull DB from real physical device then it's not possible. Instead of you should export DB in your SDCard... — M D, Sep 24 '14 at 11:10
If you are trying on emulator please try closing and restarting your emulator, if it dont work create new emulator. If it's a device then you cannot pull the db you can write code in you application to copy the db in you sd card and then you can use it from there. — Amitabh Sarkar, Sep 24 '14 at 11:12
@AmitabhSarkar Please read question carefully before posting answer or comment. — SilentKiller, Sep 24 '14 at 11:18
assuming your device is rooted, extract the db with a file manager like ES File Explorer or RootExplorter. — Phantômaxx, Sep 24 '14 at 11:20

score 0 · Answer 1 · answered Sep 24 '14 at 11:35

If your device isn't rooted, you may use this code to export your applications database onto your sdcard:

try {
   File dstDb = new File(dstPathOnSdcard, dstFileName);
   FileOutputStream output = new FileOutputStream(dstDb);

   File srcDb = new File(Environment.getDataDirectory(), "//data//com.mynamespace.myapp//databases//mydatabasename.db");
   FileInputStream input = new FileInputStream(srcDb);

   FileChannel src = input.getChannel();
   WritableByteChannel dst = Channels.newChannel(output);

   src.transferTo(0, src.size(), dst);

   src.close();
   input.close();
   dst.close();
   output.close();
} 
catch (Exception e) {
   // doSomething
}

score 0 · Answer 2 · answered Jun 18 '18 at 13:13

This is how I do it (on an ubuntu machine, without root):

Locate adb file in Android/Sdk/platform-tools/
Open command line in this directory
Run the following code, to pull Sqlite database from app to SD card:

./adb -d shell "run-as com.example.name.myappname cp /data/data/com.example.name.myappname /databases/database.db /sdcard/database.db"

*Make sure to replace "database.db" and "com.example.name.myappname", by your databasename and app name (found in your manifest).

Run the following code, to pull the Sqlite data from SD card to desktop:

./adb -d pull /sdcard/database.db ~/Desktop/database.db

Unable to View or pull SQLite database from device

2 Answers2