Sqlite database is not visible in sdcard when I use windows file manager

Question

I changed the default directory of my database to the sdcard and I want to acccess this database and see its data using sqlitebrowser ,However I can see this database from my android file manager but when I am using windows file manager I cannot see the file of database in my sdcard , I thing it is about permission issues , But How can I solve that ?

my database is here

public static String SDCard =  Environment.getExternalStorageDirectory().getAbsolutePath()
    + File.separator ;
    public DatabaseHelper(Context context) {


        super(context, SDCard +DATABASE_NAME, null, DATABASE_VERSION);
        transactionManager = new TransactionManager(getConnectionSource());
    }

possible duplicate of [Database not visible in DDMS folder when real device used instead of emulator](http://stackoverflow.com/questions/18437347/database-not-visible-in-ddms-folder-when-real-device-used-instead-of-emulator) — deadfish, Jan 07 '14 at 13:44
Do you mean that when you connect your phone to PC and open SDCard , you can't see the database? — Rohan Kandwal, Jan 07 '14 at 13:48
it is a different question because I changed the default location to the sdcard — Mohammed Subhi Sheikh Quroush, Jan 07 '14 at 13:49
In Windows explorer, make sure you have "Show hidden files and folders" enabled. — laalto, Jan 07 '14 at 13:50
How are you mounting the card on Windows? USB mass storage or MTP? — laalto, Jan 07 '14 at 13:56
Windows explorer, make sure you have "Show hidden files and folders" enabled , didn't work for me :( — Mohammed Subhi Sheikh Quroush, Jan 07 '14 at 14:58
@deadfish It's not a duplicate as user has already changed the database location from default to SD-Card so as SD-card is getting created onto SD-card, he/she must be able to see/view it. — Paresh Mayani, Feb 28 '14 at 09:44
@PareshMayani - a lot changed since fist version of this topic, so it might be not duplicate now — deadfish, Feb 28 '14 at 10:16
@deadfish agree but I just posted a comment with the aim to prevent the duplicate votes. — Paresh Mayani, Feb 28 '14 at 10:17

score 1 · Accepted Answer · answered Jan 07 '14 at 15:26

1

Some Android phones have their internal memory split into two blocks.

One is used for the internal or / folder. The other part of the internal memory is returned by getExternalStorageDirectory(). This is still internal memory from user and/or PC side. But for Android it is external memory.

So probably you are looking in the wrong folder.

For example in my Samsung S4 I have:

  /
  /storage/emulated/0
  /storage/extSdCard

"/storage/emulated/0" is returned from getExternalStorageDirectory(), while "/storage/extSdCard" is my external SD card.

answered Jan 07 '14 at 15:26

GvS

52,015
16
101
139

How could I edit the code to put the file on the top of my sdcard – Mohammed Subhi Sheikh Quroush Jan 07 '14 at 16:13
@MohammedSubhiSheikhQuroush, That sir, is a very good question. Since all devices I have seen use a different path to mount the SdCard, you can only ask the user for the path. (And the user will probably not know). – GvS Jan 07 '14 at 16:19
@MohammedSubhiSheikhQuroush, I found this answer to be helpfull: http://stackoverflow.com/a/18871043/11492 – GvS Jan 08 '14 at 08:35

score 0 · Answer 2 · edited May 23 '17 at 12:19

Physical Device

You need to have a phone with root access in order to browse the data folder (data/data/your.app.package.name) on an Android phone which means either you have a developer device or you've rooted your device.

(You also need to be running ADB in root mode and this can be achieved on the commandline using adb root)

If your phone does not have root access, you will not be able to gain access to the database.

The database will have rw-rw---- as the permission as default. In order to access the database you should change the permission level using chmod on *nix systems or through the folder permission dialogs in Windows (right click the folder and set permissions to everyone)

Emulated Device

See this previous answer. You can access the database using the DDMS perspective

The user clearly states that database is in SDCard not in data thus root access is not required. — Rohan Kandwal, Jan 07 '14 at 13:43

score 0 · Answer 3 · answered Jan 07 '14 at 15:08

Mounting a device in MTP mode has a bug where the MTP database isn't updated correctly and newly created objects are not visible to the client computer.

As a workaround, you can use MediaScannerConnection scanFile() to force refresh the database after creating your directories/files.

Sqlite database is not visible in sdcard when I use windows file manager

3 Answers3

Physical Device

Emulated Device