Copy sqlite database from device to PC

Question

I have an android program that stores its information in a sqlite database. Will it be straighforward to copy that db file to a pc once the device is plugged via USB or should a special functionality be written in the program itself to dump the db contents to a file under the /sdcard directory ?

Thanks

Maybe this answer helps: http://stackoverflow.com/questions/6928849/debugging-sqlite-database-on-the-device — Reinhold, Jan 03 '13 at 08:05
Possible duplicate of [Android - Pulling SQlite database android device](http://stackoverflow.com/questions/9997976/android-pulling-sqlite-database-android-device) — Amir Ali Akbari, Jul 05 '16 at 11:12

score 9 · Answer 1 · answered May 16 '11 at 01:08

9

You can use the adb pull command to read a file from the teathered device to your desktop, e.g. adb pull /data/data/com.foo.bar/databases/MyDatabase

answered May 16 '11 at 01:08

superfell

18,780
4
59
81

Wow, in my case it IS signed. – xain May 16 '11 at 01:22
Yes, its not really clear if the question is about a one off development task, or about an actual product feature. – superfell May 16 '11 at 03:41
You're right ... It's about a product feature that if not present, a workaround can be implemented via coding. – xain May 16 '11 at 04:27

score 1 · Answer 2 · answered Nov 26 '19 at 06:43

You can create a bat file and run it , it will create a folder name clonedb and pull all database to this

adb shell rm -rf /sdcard/clonedb
adb shell run-as <app package> cp -r /data/data/<app package>/databases/. /sdcard/clonedb
adb pull /sdcard/clonedb ./

Copy sqlite database from device to PC

2 Answers2