android - restore sqlite database from internal storge to appication

Question

I am trying to restore a database from the phone storage in order to use it in my application. I successfully did a backup for my database to the internal storage but when I am trying to restore it the following io.exception pops up

java.io.IOException: open failed: ENOENT (No such file or directory)

How can I solve this problem? However, I tried the follosing existing solutions but they didn't work Android - java.io.FileNotFoundException, is it possible backup and RESTORE a database file in android? non root devices, Restoring SQLite DB file

private void restoreDatabase(Context context) {
    String packagename = getPackageName();

    File sdcard = Environment.getExternalStorageDirectory();
    File data = Environment.getDataDirectory();

    try {
        if (sdcard.canWrite()) {
            String currentDBPath = "//data/"+getPackageName() +"/databases/" + DATABASE_NAME;
            String backupDBPath = DATABASE_NAME;
            File currentDB = new File(data, currentDBPath);
            File backupDB = new File(sdcard, backupDBPath);
            currentDB.createNewFile();

            if (currentDB.exists()) {
                FileChannel src = new FileInputStream(backupDB).getChannel();
                FileChannel dst = new FileOutputStream(currentDB).getChannel();
                dst.transferFrom(src, 0, src.size());
                src.close();
                dst.close();
                Toast.makeText(getApplicationContext(), "Database Restored successfully", Toast.LENGTH_SHORT).show();
            }
        }
    } catch (FileNotFoundException e) {
        e.printStackTrace();
        Toast.makeText(context, e.toString(), Toast.LENGTH_LONG).show();

    } catch (IOException e) {
        e.printStackTrace();
        Toast.makeText(context, e.toString(), Toast.LENGTH_LONG).show();
    }
}

Please don't mark this question as duplicate

do you want to import an excisting database to your app data and use it later? — Hoda Arezoudar
– Hoda Arezoudar, Commented Aug 29, 2018 at 11:57

Hoda Arezoudar · Accepted Answer · 2018-08-29 12:39:02Z

3

after exporting your database you can use this function to import the database, I had it testet and it works fine :

private void importDB() {
        String appDataPath = getApplicationContext().getApplicationInfo().dataDir;

        File dbFolder = new File(appDataPath + "/databases");//Make sure the /databases folder exists
        dbFolder.mkdir();//This can be called multiple times.
        //EDITED
        File dbFilePath = new File(appDataPath + "/databases/"+"yourDataBaseName");

        try {
        //EDITED
            File file = new File(Environment.getExternalStorageDirectory().getAbsolutePath() + File.separator + "YourBackupFolder","yourDataBaseFileName);
        FileInputStream inputStream = new FileInputStream(file); //use your database name
            OutputStream outputStream = new FileOutputStream(dbFilePath);
            byte[] buffer = new byte[1024];
            int length;
            while ((length = inputStream.read(buffer))>0)
            {
                outputStream.write(buffer, 0, length);
            }
            outputStream.flush();
            outputStream.close();
            inputStream.close();

        } catch (IOException e){
            //handle

            e.printStackTrace();
        }
    }

edited Aug 29, 2018 at 12:39

answered Aug 29, 2018 at 12:04

Hoda Arezoudar

4082 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Ahmad Over a year ago

It didnt work for me. My database exists on the phone storage and I want to import it into my application. Your code gives me a IO exception on InputStream inputStream = getApplicationContext().getAssets().open(DATABASE_NAME);

Hoda Arezoudar Over a year ago

@Mohamad i have eddited my answer see the new dbFilePath.

Hoda Arezoudar Over a year ago

@Mohamad you should use your own database name instead of DATABASE_NAME

Ahmad Over a year ago

I am storing the database name in DATABASE_NAME. I think you reversed the streams, the input stream should point to the db on external storage, and the output stream should be the db file in the application

Ahmad Over a year ago

Thank you, the code works well, I edited it to fix a small bug

Collectives™ on Stack Overflow

android - restore sqlite database from internal storge to appication

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related