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, Nov 12 '18 at 16:47
https://stackoverflow.com/questions/1995320/how-do-i-backup-a-database-file-to-the-sd-card-on-android — ॐ Rakesh Kumar, Nov 12 '18 at 16:50
@earthw0rmjim Any approach in which I can get the original state retained without the network. — Mohammedsalim Shivani, Nov 12 '18 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, Nov 12 '18 at 17:17
Thank you guys for your help. Finally, I found a [sample on GutHub](https://github.com/prof18/Database-Backup-Restore) to implement what I needed. Now, my app is having some issues with Firebase so haven't tested the feature. Will surely update once its resolved. — Mohammedsalim Shivani, Nov 18 '18 at 13:13

score 3 · Answer 1 · answered Nov 12 '18 at 16:46

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();
        }

    }

*//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, Nov 12 '18 at 18:52
@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). — MikeT, Nov 12 '18 at 19:16

score 2 · Accepted Answer · answered Nov 23 '18 at 16:03

2

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

answered Nov 23 '18 at 16:03

Mohammedsalim Shivani

1,793
3
19
30

1

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. – kksal55 Jan 21 '19 at 01:03
What trouble are you facing? I haven't tried the `Google Drive` backup, as I didn't need that. – Mohammedsalim Shivani Jan 21 '19 at 05:00
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. – kksal55 Jan 21 '19 at 12:57
Is your sqlite DB residing in the assets folder? – Mohammedsalim Shivani Jan 21 '19 at 13:10
Yeah. Inside the Assets folder. – kksal55 Jan 21 '19 at 21:20
[https://stackoverflow.com/questions/15401177/sqlite-db-in-assets-folder](This) thread says you can't copy your DB to the assets folder. – Mohammedsalim Shivani Jan 22 '19 at 07:16

Backup SQLite Database in Android

2 Answers2