How do I pull the sqlite database from the android device? [duplicate]

Question

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

Answer 1

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" 

Answer 2

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

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