Geek Answers Handbook

In android sdk1.5 where can I find my Sqlite Db on my system

I am creating an Android application, and in this application I created one DB.

I am querying the values ​​in the database and it works fine.

I need to know where SQLite DB is stored on my system.

Can you give me a way, please?

Thanks!

+4
source share
3 answers

By default, the sqlite database will be located in the following directory:

/data/data/YOUR_APP_NAMESPACE/databases/YOUR_DB_NAME.db

So, for example, the actual database containing SMS messages in your phone:

 /data/data/com.android.providers.telephony/databases/mmssms.db

In the emulator, you can directly access these files; when connecting to a real phone, you will need root access for direct access to db files.

In the android document you will find a brief overview: http://developer.android.com/intl/de/guide/developing/tools/adb.html

+6
source

"All databases, SQLite and others, are stored on the device in / data / data / package _name / databases." here

You can use android Explorer to view / pull the file from the device.

1) You specified any path during the creation / opening of the database.
In my case, I used SQLiteDatabase.openOrCreateDatabase to create the database, and this requires the database path as the first parameter.

SQLiteDatabase sqldb = SQLiteDatabase.openOrCreateDatabase ( DATABASE_PATH + DATABASE_NAME , null);

2) If you use something like this
openOrCreateDatabase ("test.db", this.MODE_APPEND, null);

Your database will be in / data / data / package_name / databases

+1
source

to access your database. If you can not find the data / data, etc.

then go to eclipse, select Window> open Perespective> other> DDMS, and then find data / data / package / database / your db

0
source

More articles:


All Articles