How do I backup a database file to the SD card on Android?

by

This code works for me!

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

        if (sd.canWrite()) {
            String currentDBPath = "//data//{package name}//databases//{database name}";
            String backupDBPath = "{database name}";
            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) {
    }

Does anyone know if this will work on non-root phones? I have only tried it on a rooted G1.

More Related Contents:

  1. Version of SQLite used in Android?
  2. Android Pre-Populated Database [duplicate]
  3. How to backup sqlite database?
  4. Android: Where are database files stored?
  5. Can I download an SQLite db on /sdcard and access it from my Android app?
  6. Populate Android Database From CSV file?
  7. Populating Spinner From SQLite Database Android
  8. SQLiteOpenHelper – creating database on SD card
  9. Backup/Restore a dockerized PostgreSQL database
  10. which is better every user have a table or just a row [closed]
  11. Database development mistakes made by application developers [closed]
  12. Copying PostgreSQL database to another server
  13. Simple export and import of a SQLite database on Android
  14. What is NoSQL, how does it work, and what benefits does it provide? [closed]
  15. Spring Security:password encoding in DB and in applicationContext
  16. SQL Server Connection Strings – dot(“.”) or “(local)” or “(localdb)”
  17. Synchronous database queries with Node.js
  18. What is the recommended way to delete a large number of items from DynamoDB?
  19. Supertype-subtype database design
  20. Storing time-series data, relational or non?
  21. How to use SharedPreferences to save more than one values?
  22. Good Free Alternative To MS Access [closed]
  23. What’s wrong with nullable columns in composite primary keys?
  24. Convert String ISO-8601 date to oracle’s timestamp datatype
  25. Are Cloud Firestore queries still case sensitive?
  26. How should you build your database from source control?
  27. UNIQUE constraint failed: sqlite database : android
  28. SQL DataType – How to store a year?
  29. Any example of a necessary nullable foreign key?
  30. Mysql service won’t start, InnoDB init function error

Leave a Comment