Backup SQLite Database in Android

Question

I need to make an offline backup of the SQLite database in the mobile's internal storage or the SD Card. But I am clueless, how's this possible.

I followed many threads here on SO, but they suggest copying the DB one location to other, which is not suitable for me, neither to the Google Drive.

Any guidance would be precious.

1. copy your db to sdcard 2. if reinstall, copy db back to the app. — Kingfisher Phuoc
– Kingfisher Phuoc, Commented Nov 12, 2018 at 16:47
@earthw0rmjim Any approach in which I can get the original state retained without the network. — Mohammedsalim Shivani
– Mohammedsalim Shivani, Commented Nov 12, 2018 at 17:15
@RakeshKumar I already checked that thread, but I am not able to copy anything in my emulator. (Not tried in any physical device). — Mohammedsalim Shivani
– Mohammedsalim Shivani, Commented Nov 12, 2018 at 17:17

astric mobiles · Accepted Answer · 2018-11-12 16:46:19Z

4

I used this approach.

public string DATABASE_NAME = "YOUR DATABASE NAME HERE";

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

            if (sd.canWrite()) {
                Log.d("TAG", "DatabaseHandler: can write in sd");
                //Replace with YOUR_PACKAGE_NAME and YOUR_DB_NAME
                String currentDBPath = "filepath here"+DATABASE_NAME;
                //Replace with YOUR_FOLDER_PATH and TARGET_DB_NAME in the SD card
                String copieDBPath = DATABASE_NAME;
                File currentDB = new File(data, currentDBPath);
                File copieDB = new File(sd, copieDBPath);
                if (currentDB.exists()) {
                    Log.d("TAG", "DatabaseHandler: DB exist");
                    @SuppressWarnings("resource")
                    FileChannel src = new FileInputStream(currentDB).getChannel();
                    @SuppressWarnings("resource")
                    FileChannel dst = new FileOutputStream(copieDB).getChannel();
                    dst.transferFrom(src, 0, src.size());
                    src.close();
                    dst.close();
                }
            }
        } catch  (Exception e) {
            e.printStackTrace();
        }

    }

answered Nov 12, 2018 at 16:46

astric mobiles

4763 silver badges14 bronze badges

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

2 Comments

MikeT Over a year ago

//Replace with YOUR_PACKAGE_NAME and YOUR_DB_NAME, no need to hard code package name if you you use String currentDBPath = context.getDatabasepath(database).getPath(); where context is a Context and database is the database name.

MikeT Over a year ago

@MohammedsalimShivani restoring from such a file (basically reversing the backup) does work (although you may find that you need to, or that it's simpler to then restart the App). However I'd suggest, when restoring, to initially make a copy of the original DB (so that should the restore fail you can revert to the original DB).

Mohammedsalim Shivani · Accepted Answer · 2018-11-23 16:03:56Z

2

Finally, with this GitHub sample I successfully implemented whatever customization I needed. And it's live now.

answered Nov 23, 2018 at 16:03

Mohammedsalim Shivani

1,8335 gold badges20 silver badges33 bronze badges

6 Comments

kksal55 Over a year ago

I couldn't run that sample. Can you share how you did it? A kind of sqlite file google drive could not backup. Thank you in advance.

Mohammedsalim Shivani Over a year ago

What trouble are you facing? I haven't tried the Google Drive backup, as I didn't need that.

kksal55 Over a year ago

I tried to back up the sqlite database in the assets folder to google drive, but I was not successful. GDA Api has been used by google last month.

Mohammedsalim Shivani Over a year ago

Is your sqlite DB residing in the assets folder?

kksal55 Over a year ago

Yeah. Inside the Assets folder.

|

Collectives™ on Stack Overflow

Backup SQLite Database in Android

2 Answers 2

2 Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related