How to see my application database?

Question

I use Samsung galaxy S2 for debugging. How can I see my database that create by my application.

I can't find by this way

Eclipse Go To Window > Showview > Other.. > File Expolrer Click On Open

Now browse To

data/data/your.package.name/databases/<DATABASE

FILE Here >

http://stackoverflow.com/questions/1995320/how-to-backup-database-file-to-sdcard-on-android — Selvin, May 22 '13 at 09:44
root your device or copy your database into sdcard. after that show using sqlitemanager android app — Dhaval Parmar, May 22 '13 at 09:51

Jose Antonio Benitez Montero · Answer 1 · 2013-05-22T09:47:51.120

2

While you are debuging go to the DDMS tab. (With a virtual device, not with your phone)

Then search /sdcard/your aplication name/databases

** You have to configurate your AVD enter image description here

edited May 22 '13 at 09:47

answered May 22 '13 at 09:39

Jose Antonio Benitez Montero

1,846
2
19
25

score 2 · Answer 2 · edited May 22 '13 at 12:35

2

If you use emulator then go on DDMS and select device emulator then go file explore data>data>package name>database folder>.db file.

this file your database select this file and pope on any drive and open on SQLite browser.

edited May 22 '13 at 12:35

WarrenFaith

57,492
25
134
150

answered May 22 '13 at 09:47

score 1 · Answer 3 · answered May 22 '13 at 09:33

1

You can only see the database on a rooted device. So root the device or just use an emulator instance, because the emulator is rooted by default.

answered May 22 '13 at 09:33

WarrenFaith

57,492
25
134
150

score 0 · Answer 4 · answered May 22 '13 at 09:36

0

You have to root your Device to see the database of your Applications.

answered May 22 '13 at 09:36

Abhijit Chakra

3,201
37
66

this is supposed to be a comment – thepoosh May 22 '13 at 09:56
1

@thepoosh seems like an answer to me.user1480210 said there is no database files visible. rickky said that it has to be rooted. Its a solution and answers the question. – Yaroslav Mytkalyk May 22 '13 at 09:58
@thepoosh is there any specific reason kindly provide me. – Abhijit Chakra May 22 '13 at 10:00
@JohnWillemse am i asking for any clarification or request from the author ????here in my answer. – Abhijit Chakra May 22 '13 at 10:05
@rickky You're right, I'm sorry, I removed the flag. Somehow I read it as a question, but it's an answer. – John Willemse May 22 '13 at 10:15

score 0 · Answer 5 · answered May 22 '13 at 09:44

You can do it only if your device is rooted.

$ adb shell # open adb shell
$ su        # ask for superuser rights
$ cat /data/data/your.package.name/databases/database_name >> /sdcard/Download/database_name  # copy database file to a folder where you don't need root access to get it from device to PC
$ exit      # close adb shell
$ adb pull /sdcard/Download/database_name # get that copied file

Now you can browser via editor, such as sqlitebrowser

$ sqlitebrowser database_name

score 0 · Answer 6 · answered May 22 '13 at 09:48

You can access app's database ONLY IF your device is rooted!

1). Find DDMS icon in the right-top of Eclipse IDE.

2). Click "File Explorer" tag.

3). Open in order :"data--> data--> your package name-->databases".

4). Select the database you want to check and click "pull a file from the device"button in the tool bar.

5).Browse sqlite database use this.

score 0 · Answer 7 · answered May 23 '13 at 04:45

If you want to see database. The way you did is correct but if your device is not root, you can not see. But I think you can run app on Emulator and: Eclipse Go To Window > Showview > Other.. > File Expolrer Click On Open.

There are 2 ways:
1. Root your device
2. Looking for it on emulator

score 0 · Answer 8 · answered Jan 29 '14 at 09:24

I'm doing this with non-rooted device.
yes, it's really not a very short way but the only way I found, and if you have a big database that you want to be able to make queries and to explore it- that is comfortable way (on non rooted device) :

send your db file via e-mail to your pc
use sqlBrowser

now you can navigate your tables and exec sql queries on the data from your pc.

hope it will help somebody.

How to see my application database?

8 Answers8