Android: Where are the database files stored?

Question

I created a SQLite database on an Android device. The program can read / write to the database, so the database file was obviously created. SQLiteDatabase.mPath is set to

db.mPath = "/data/data/dev.client.android/databases/clientDB.db" 

but when I browse the directories on the device, I can not find the clientDB.db file. I looked into the data directory, but it seems empty.

Does anyone know what could be wrong here?

Answer 1

If you mean that you visited /data and didn’t find anything in it, and you are exploring the usual piece of Android equipment, which is expected. DDMS does not have permission to view /data .

However, at least if your application is compiled in debug mode, you can use the adb pull command on the console to download the file directly.

Answer 2

try getDatabasePath on ContextWrapper ( http://developer.android.com/reference/android/content/ContextWrapper.html ). If you are in an Activity or Application class, try:

 File dbFile = getDatabasePath(MY_DB_NAME); Log.i(dbFile.getAbsolutePath()); 

Just assuming that its value in /data/data/my.package.name/databases/ bad, because there is no guarantee that the data was not moved to the SD card, or the device / OS just decided in another data directory.

Answer 3

In debug mode, you can use adb shell and view the contents of the directory. In the shell, you can call sqlite3 / data / data / dev.client.android / databases / clientDB.db to analyze the database.