Backup SQLite database to SD card

Question

Im trying to backup my sqlite database to my sdcard and I'm trying to follow This way but I cant find the database in my sdcard. What did I do wrong?

public void exportDatabse(String DBOperations) {

    try {
        File sd = Environment.getExternalStorageDirectory();
        File data = Environment.getDataDirectory();

        if (sd.canWrite()) {
            String currentDBPath = "//data//com.example.hp.semakoperasimampatansrc//databases//attendant_info.db";
            String backupDBPath = "attendant_info_backup.db";
            File currentDB = new File(data, currentDBPath);
            File backupDB = new File(sd, backupDBPath);

            if (currentDB.exists()) {
                FileChannel src = new FileInputStream(currentDB).getChannel();
                FileChannel dst = new FileOutputStream(backupDB).getChannel();
                dst.transferFrom(src, 0, src.size());
                src.close();
                dst.close();
            }
        }
    } catch (Exception e) {
    }

How I call the method:

db.exportDatabse("attendant_info.db");

I've also have added

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

to my manifest

Aashish Aadarsh · Answer 1 · 2019-03-05T03:31:28.520

You can do same in following way and this can be used to copy not only database, but files and shared pref also (if any). Create a class called DeveloperOption and use its method copyAppDataToLocal to do same.

Runtime permission is required if target sdk is 23 or above

//package declaration
import android.app.Activity;
import android.os.Environment;
import android.util.Log;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;

public class DeveloperOption {
    public static final String BASE_PATH = Environment.getExternalStoragePublicDirectory
            ("App_BackUp").getAbsolutePath();
    public static final String SEPARATOR = "/";
    private static boolean operationStatus = true;
    private static String dataDirectory = null;
    private static String appName = "APP_NAME";

    public static boolean copyAppDataToLocal(Activity callingActivity, String appName) {

        dataDirectory = callingActivity.getApplicationInfo().dataDir;
        DeveloperOption.appName = appName;
        String TAG = "Developer_Option";
        try {
            if(dataDirectory != null) {
                copyAppData(new File(dataDirectory, "shared_prefs"),"shared_prefs");
                copyAppData(new File(dataDirectory, "files"),"files");
                copyAppData(new File(dataDirectory, "databases"),"databases");
            } else {
                Log.e(TAG, "!!!!!Unable to get data directory for ACTIVITY-->" + callingActivity
                        .toString());
            }
        } catch (Exception ex) {
            Log.e(TAG, "!!!!@@@Exception Occurred while copying DATA--->"+ex.getMessage(),ex.fillInStackTrace());
            operationStatus = false;
        }

        return operationStatus;
    }

    private static void copyFileToStorage(String directoryName, String inFile, String fileName, boolean
            isDirectory, String subdirectoryName) {
        try {
            FileInputStream myInput = new FileInputStream(inFile);
            File out_dir;
            if(!isDirectory) {
                out_dir = new File(BASE_PATH+ SEPARATOR + appName +
                        SEPARATOR + directoryName);
            } else {
                out_dir = new File(BASE_PATH + SEPARATOR + appName +
                        SEPARATOR + directoryName + SEPARATOR + subdirectoryName);
            }
            if(!out_dir.exists()) {
                operationStatus = out_dir.mkdirs();
            }
            String outFileName = out_dir + "/" + fileName;
            OutputStream myOutput = new FileOutputStream(outFileName);
            byte[] buffer1 = new byte[1024];
            int length;
            while ((length = myInput.read(buffer1)) > 0) {
                myOutput.write(buffer1, 0, length);
            }
            myOutput.flush();
            myOutput.close();
            myInput.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    private static void copyAppData(File fileTypeToBeCopied, String outDirectoryName){
        if(fileTypeToBeCopied.exists() && fileTypeToBeCopied.isDirectory()) {
            File[] files = fileTypeToBeCopied.listFiles();
            for (File file : files) {
                if(file.isFile()) {
                    copyFileToStorage(outDirectoryName, file.getAbsolutePath(), file.getName(), false, "");
                } else {
                    String folderName = file.getName();
                    File databaseDirsNew = new File(dataDirectory, outDirectoryName+"/" + folderName);
                    if(databaseDirsNew.exists() && databaseDirsNew.isDirectory()) {
                        File[] filesDB = databaseDirsNew.listFiles();
                        for (File file1 : filesDB) {
                            if(file1.isFile()) {
                                copyFileToStorage(outDirectoryName, file1.getAbsolutePath(), file1.getName(),
                                        true, folderName);
                            }
                        }
                    }
                }
            }
        }
    }
}

Since it is a static method, you need not to make an object. Rather just use DeveloperOption.copyAppDataToLocal(this,getString(R.string.app_name); You need to pass activity context and app name as parameter and since it is a static method, it should not be called from non static context. Otherwise you can remove static keyword and follow your approach. — Aashish Aadarsh, May 11 '17 at 09:14

score 0 · Accepted Answer · answered May 11 '17 at 08:55

Try adding runtime permission request for Android 6.0 (API Level 23) and above, from official docs

Code for getting WRITE_EXTERNAL_STORAGE permission

if (Build.VERSION.SDK_INT > Build.VERSION_CODES.LOLLIPOP_MR1 && !checkIfAlreadyhavePermission()) {
        requestForSpecificPermission();
    }

private boolean checkIfAlreadyhavePermission() {
    if (checkSelfPermission(Manifest.permission.WRITE_EXTERNAL_STORAGE) != PackageManager.PERMISSION_GRANTED) {
        return false;
    }
    return true;
}

Ask for permission else like this

private void requestForSpecificPermission() {
    requestPermissions(new String[]{Manifest.permission.WRITE_EXTERNAL_STORAGE}, 101);
}

score 0 · Answer 3 · answered May 11 '17 at 08:59

try out this.

public void exportDatabse(String DBOperations){
    File sd = Environment.getExternalStorageDirectory();
        File data = Environment.getDataDirectory();
       FileChannel source=null;
       FileChannel destination=null;
       String currentDBPath = "//data//com.example.hp.semakoperasimampatansrc//databases//attendant_info.db";
       String backupDBPath = DBOperations;
       File currentDB = new File(data, currentDBPath);
       File backupDB = new File(sd, backupDBPath);
       try {
            source = new FileInputStream(currentDB).getChannel();
            destination = new FileOutputStream(backupDB).getChannel();
            destination.transferFrom(source, 0, source.size());
            source.close();
            destination.close();
            Toast.makeText(this, "DB Exported!", Toast.LENGTH_LONG).show();
        } catch(IOException e) {
            e.printStackTrace();
        }
}

Backup SQLite database to SD card

3 Answers3