Extract application database from android device through adb

Question

How can I extract the database of an application from an android device through an adb shell command?

Answer 1

If you have neither SD card nor root on your device, just use adb shell.

$ adb shell
$ run-as com.your.package cat /data/data/com.your.package/databases/your_db > /storage/sdcard0/Download/your.db

Then use DDMS to pull file out.

Answer 2

Databases are stored in files, mostly on internal storage, in App's data directory like :

/data/data/com.example.myapp/mydb 

so you can do

adb pull /data/data/com.example.myapp/mydb

Then you can use some software to open that file, and work with data base. To place it back:

adb push <new file> /data/data/com.example.myapp/mydb

Answer 3

As of Android 9, the Download directory has moved to /storage/emulated/0/Download/. I combined this answer and this answer with the new location to pull the database file:

1. run-as com.packagename
2. cp /data/data/com.packagename/databases/databaseName.db databaseNameNewFile.db
3. cp databaseNameNewFile.db /storage/emulated/0/Download

Then I enabled file transfer on the phone, opened it with File Explorer, went to Internal Storage/Download, found the database file, and copied it to my computer.

Answer 4

AFAIK you can fetch databases only from Android Emulator, not from real device (unless the device is rooted).
To do so, simply go to DDMS --> File Explorer --> data --> data --> your package name -- > databases

Your database should be inside databases folder

Once you select your database, you will see two icons on the upper tab wherein you can push or pull the database.

Answer 5

I dont think u can extract extract database from device, but yes you can extract it from emulator from DDMS > File Explorer > data > data > package > databases