Find Sqlite Database on Android

Question

Next, I’m creating an application for Android, where I use a local Sqlite bank, never gave any kind of problem of registration or database query, so I never had to take the bank direct in the emulator, but now I’m in need, the problem is, I can’t locate this database, it’s created, it has data, I just can’t locate it. I use Android Studio, I’ve looked in Android Device Monitor, but I can’t open the folder "data", as it is empty. The strange thing is that if I try to create a "date/date" folder it says that the file already exists. How can I recover this database?

Answer 1

The reason why subdirectories do not appear in the folder Data is the adb not having permission to read its contents.

Use the Device File Explorer.

You can open it through View > Windows Tool > Device File Explorer or by clicking the existing button on the lower right side of Android Studio.

You can interact with the content by right-clicking to create a new one, save the selected file or folder to your pc, delete or sync.

Notes:

• Requires Android Studio 3.0 or higher
• The contents of the folder Data is only visible if the device is an emulator.

Answer 2

In case you do not find the file through the "Device File Explorer" window, you can use the code below:

try {

    /* Captura o arquivo original */
    File src = new File(Environment.getDataDirectory(), "//data//".concat(getPackageName()).concat("//databases//SEU-BANCO.db"));

    /* Captura o caminho do arquivo de destino */
    File dst = new File(Environment.getExternalStorageDirectory().getPath().concat("/SEU-BANCO-BACKUP.db"));

    /* Cria o arquivo de destino */
    dst.createNewFile();

    /* Abre o arquivo original e o de destino para leitura e escrita, respectivamente */
    FileInputStream inputStream = new FileInputStream(src);
    FileOutputStream outputStream = new FileOutputStream(dst);
    int b = 0;

    /* Ler o conteúdo em byte do arquivo original e escreve no arquivo de destino */
    while ((b = inputStream.read()) != -1) {
        outputStream.write(b);
    }

    /* Fecha as conexões */
    outputStream.close();
    inputStream.close();
} catch (Exception e) {
    e.printStackTrace();
}