Skip to main content

Debug Database with adb in Andoid

When I have created the sqlite database directly from my application. I am not getting where the database actually stored with application

Then I found that the system stores databases in the /data/data/package_name/databases folder by default.

To access that database We can use adb
Android Debug Bridge (adb) is a versatile tool lets you manage the state of an emulator instance or Android-powered device
  1. adb -s emulator-5554 shell
    adb -s <serialNumber> <command>
  2. sqlite3 /data/data/package_name/databases/database_name
Now you can access sqlite promt 
sqlite> .databases

which display 
seq  name             file                                                     
---  ---------------  ----------------------------------------------------------
1    main          data/data/package_name/databases/databasename
                                                         

Labels:

Comments

Developer said…
Hi,Padma
I am new in Android Development.
Please explain me how to connect database in android.
Thanks in Advance
June 11, 2010 at 8:32 PM
Post a Comment

Popular posts from this blog

Are you afraid of the dark!!! -Sidney Sheldon

I have just finished reading this book ............... The book starts with the cops who find the dead bodies of various scientists. It tells us briefly about the lives of the two widows when they were married rather happily married. One widow being a high profile model the other being a girl next door kind of a person. This book is a story of the wives of two good scientist who escape death several times. The two lose their husband as they were murdered for being involved in a very high profile undercover project. The book describes how the two widows decide to find out the person involved in murdering their husband and in the process how do they escape death several times and finally whether did they die or not ? is a question which will be answered only after reading the book. ARE YOU AFRAID OF THE DARK? is a pleasant and easy read. While the story has its flaws, it certainly held my interest and kept me reading to the very end.
4 comments
Read more

Touching One .......................

Little girl and her father were crossing a bridge. The father was kind of scared so he asked his little daughter, "Sweetheart, please hold my hand so that you don't fall into the river. " The little girl said, "No, Dad. You hold my hand. " "What's the difference?" Asked the puzzled father. "There's a big difference, " replied the little girl. "If I hold your hand and something happens to me,chances are that I may let your hand go. But if you hold my hand, I know for sure that no matter what happens, you will never let my hand go. " In any relationship, the essence of trust is not in its bind, but in its bond. "So hold the hand of the person whom you love rather than expecting them to hold urs... this story tells many things... u just need to understand the meaning rest depends on u "
4 comments
Read more

Welcome 2009 ...A new year resolution

A new year resolution I think this is a good time to sit back and reflect on the things we'v done and those we hvnt,the thingz we'v done right and those we did wrong,and the times we impressed and dissapointed ourselves and others..THEN make decisions based on our thoughts. I thought to write this year resolution that is to be SMART ( Specific, Measurable, Achievable, Realistic and Time-bound ) and listed to on my blog HAPPY NEW YEAR EVERYONE!! Live UR Life
4 comments
Read more