Backup/restore sqlite db in android [duplicate]

by

In the folder “/data/data/’your.app.package’/databases/” you have a .db file that is your database. You can copy that file, save it, and then place it back there again.

One example on how to backup the database to the external storage:

    final String inFileName = "/data/data/<your.app.package>/databases/foo.db";
    File dbFile = new File(inFileName);
    FileInputStream fis = new FileInputStream(dbFile);

    String outFileName = Environment.getExternalStorageDirectory()+"/database_copy.db";

    // Open the empty db as the output stream
    OutputStream output = new FileOutputStream(outFileName);

    // Transfer bytes from the inputfile to the outputfile
    byte[] buffer = new byte[1024];
    int length;
    while ((length = fis.read(buffer))>0){
        output.write(buffer, 0, length);
    }

    // Close the streams
    output.flush();
    output.close();
    fis.close();

More Related Contents:

  1. I am getting this error on my code [closed]
  2. Sqlite for Android
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  5. Best way to work with dates in Android SQLite [closed]
  6. Android database encryption
  7. How do I join two SQLite tables in my Android application?
  8. How can I create a user-defined function in SQLite?
  9. SQLite Android Database Cursor window allocation of 2048 kb failed
  10. Android SQLite: Update Statement
  11. How to delete SQLite database from Android programmatically
  12. Android error – close() was never explicitly called on database
  13. How do I create a database in android? [closed]
  14. Android SimpleCursorAdapter doesn’t update when database changes
  15. How to implement Export sqlite To excel/csv file in android?
  16. How to store and retrieve a byte array (image data) to and from a SQLite database?
  17. problem about sqlite database, no such table:
  18. SQLite Query in Android to count rows
  19. Using the LIMIT statement in a SQLite query
  20. sqlite encryption for android
  21. Retrieve large blob from Android sqlite database
  22. Attempt to reopen an already-closed object sqlitedatabase
  23. How insert image in room persistence library?
  24. How to access an existing sqlite database in Android?
  25. DB File in Assets Folder. Will it be Updated?
  26. Sqlite issues with HTC Desire HD
  27. difference between rawquery and execSQL in android sqlite database
  28. Compare dates (stored as string) in android sqlite database?
  29. H2 Database vs SQLite on Android [closed]
  30. Backup Room database

Leave a Comment