sqlite browser: where is the db file?

Question

I would like examine androids internal database files using a sqlite browser. From my understanding contacts, etc. is stored in an sql lite db on Android. Now I want to read these tables using sqlite browser. For that I need to specify the db file, but where is it located?

The question is where is the location for the emulator?

Where is it located on a real device?

Can I access it on a real device which is not rooted?

duplicate: http://stackoverflow.com/questions/1510840/where-does-android-emulator-store-sqlite-database — fazo, Mar 07 '11 at 15:12

score 7 · Accepted Answer · answered Mar 07 '11 at 15:10

7

All databases are saved in:

/data/data/the.app.package.name/databases/the_name_of_db

And no, you cannot access that file in a non-rooted phone. Fortunately the emulator is rooted.

answered Mar 07 '11 at 15:10

Cristian

198,401
62
356
264

1

Actually, you can access that location on a non-rooted phone, if you've enabled "USB debugging" under "developer options" and connected the device by USB cable to a computer. – LarsH Jun 09 '20 at 20:20

score 1 · Answer 2 · answered Mar 07 '11 at 15:27

1

Open your application with emulator and go in DDMS. Then in FileExplorer go into data/data/application.package.name/databases/name_of_your_database. Then pull it from device

answered Mar 07 '11 at 15:27

NewUser

46
1

sqlite browser: where is the db file?

2 Answers2