Simple export and import of a SQLite database on Android

Question

I am trying to implement a simple SQLite export import for backup purposes  Export is just a matter of storing a copy of the raw current db file  What I want to do for import is to just delete the old current db file and rename the imported db file to current db  Is this possible  When I try this solution  I get the following error   06-30 13 33 38 831  ERROR SQLiteOpenHelper 23570       android database sqlite SQLiteDatabaseCorruptException  error code 11  database disk image is malformed   If I look at the raw database file in a SQLite browser it looks fine

User · Answer

To export db rather it is SQLITE or ROOM:

Firstly, add this permission in AndroidManifest.xml file:

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

Secondly, we drive to code the db functions:

private void exportDB() {
    try {
        File dbFile = new File(this.getDatabasePath(DATABASE_NAME).getAbsolutePath());
        FileInputStream fis = new FileInputStream(dbFile);

        String outFileName = DirectoryName + File.separator +
                DATABASE_NAME + ".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();


    } catch (IOException e) {
        Log.e("dbBackup:", e.getMessage());
    }
}

Create Folder on Daily basis with name of folder is Current date:

public void createBackup() {

    sharedPref = getSharedPreferences("dbBackUp", MODE_PRIVATE);
    editor = sharedPref.edit();

    String dt = sharedPref.getString("dt", new SimpleDateFormat("dd-MM-yy").format(new Date()));

    if (dt != new SimpleDateFormat("dd-MM-yy").format(new Date())) {
        editor.putString("dt", new SimpleDateFormat("dd-MM-yy").format(new Date()));

        editor.commit();
    }

    File folder = new File(Environment.getExternalStorageDirectory() + File.separator + "BackupDBs");
    boolean success = true;
    if (!folder.exists()) {
        success = folder.mkdirs();
    }
    if (success) {

        DirectoryName = folder.getPath() + File.separator + sharedPref.getString("dt", "");
        folder = new File(DirectoryName);
        if (!folder.exists()) {
            success = folder.mkdirs();
        }
        if (success) {
            exportDB();
        }
    } else {
        Toast.makeText(this, "Not create folder", Toast.LENGTH_SHORT).show();
    }

}

Assign the DATABASE_NAME without .db extension and its data type is string

User · Answer

I use this code in the SQLiteOpenHelper in one of my applications to import a database file   EDIT   I pasted my FileUtils copyFile   method into the question   SQLiteOpenHelper  public static String DB FILEPATH     data data  package name  databases database db           Copies the database file at the specified location over the current    internal application database        public boolean importDatabase String dbPath  throws IOException           Close the SQLiteOpenHelper so it will commit the created empty        database to internal storage      close        File newDb   new File dbPath       File oldDb   new File DB FILEPATH       if  newDb exists              FileUtils copyFile new FileInputStream newDb   new FileOutputStream oldDb               Access the copied database so SQLiteHelper will cache it and mark            it as created          getWritableDatabase   close            return true            return false      FileUtils  public class FileUtils                  Creates the specified  lt code gt toFile lt  code gt  as a byte for byte copy of the         lt code gt fromFile lt  code gt   If  lt code gt toFile lt  code gt  already exists  then it        will be replaced with a copy of  lt code gt fromFile lt  code gt   The name and path        of  lt code gt toFile lt  code gt  will be that of  lt code gt toFile lt  code gt   lt br  gt          lt br  gt          lt i gt  Note   lt code gt fromFile lt  code gt  and  lt code gt toFile lt  code gt  will be closed by        this function  lt  i gt                  param fromFile                   - FileInputStream for the file to copy from          param toFile                   - FileInputStream for the file to copy to              public static void copyFile FileInputStream fromFile  FileOutputStream toFile  throws IOException           FileChannel fromChannel   null          FileChannel toChannel   null          try               fromChannel   fromFile getChannel                toChannel   toFile getChannel                fromChannel transferTo 0  fromChannel size    toChannel             finally               try                   if  fromChannel    null                        fromChannel close                                    finally                   if  toChannel    null                        toChannel close                                                        Don t forget to delete the old database file if necessary

User · Answer

If you want this in kotlin   And perfectly working   private fun exportDbFile          try              Existing DB Path         val DB PATH     data packagename databases mydb db          val DATA DIRECTORY   Environment getDataDirectory           val INITIAL DB PATH   File DATA DIRECTORY  DB PATH             COPY DB PATH         val EXTERNAL DIRECTORY  File   Environment getExternalStorageDirectory           val COPY DB     mynewfolder mydb db          val COPY DB PATH   File EXTERNAL DIRECTORY  COPY DB           File COPY DB PATH parent    mkdirs           val srcChannel   FileInputStream INITIAL DB PATH  channel          val dstChannel   FileOutputStream COPY DB PATH  channel         dstChannel transferFrom srcChannel 0 srcChannel size            srcChannel close           dstChannel close          catch  excep  Exception            Toast makeText this  ERROR IN COPY  excep  Toast LENGTH LONG  show           Log e  FILECOPYERROR gt  gt  gt  gt   excep toString            excep printStackTrace

User · Answer

Import and Export of a SQLite database on Android  Here is my function for export database into device storage  private void exportDB        String DatabaseName    Sycrypter db       File sd   Environment getExternalStorageDirectory        File data   Environment getDataDirectory        FileChannel source null      FileChannel destination null      String currentDBPath     data     com synnlabz sycryptr     databases   DatabaseName       String backupDBPath   SAMPLE DB NAME      File currentDB   new File data  currentDBPath       File backupDB   new File sd  backupDBPath       try           source   new FileInputStream currentDB  getChannel            destination   new FileOutputStream backupDB  getChannel            destination transferFrom source  0  source size             source close            destination close            Toast makeText this   Your Database is Exported      Toast LENGTH LONG  show          catch IOException e            e printStackTrace              Here is my function for import database from device storage into android application  private void importDB        String dir Environment getExternalStorageDirectory   getAbsolutePath        File sd   new File dir       File data   Environment getDataDirectory        FileChannel source   null      FileChannel destination   null      String backupDBPath     data com synnlabz sycryptr databases Sycrypter db       String currentDBPath    Sycrypter db       File currentDB   new File sd  currentDBPath       File backupDB   new File data  backupDBPath        try           source   new FileInputStream currentDB  getChannel            destination   new FileOutputStream backupDB  getChannel            destination transferFrom source  0  source size             source close            destination close            Toast makeText this   Your Database is Imported      Toast LENGTH SHORT  show          catch  IOException e            e printStackTrace

User · Answer

This is a simple method to export the database to a folder named backup folder you can name it as you want and a simple method to import the database from the same folder a      public class ExportImportDB extends Activity            Override         protected void onCreate Bundle savedInstanceState                   TODO Auto-generated method stub             super onCreate savedInstanceState     creating a new folder for the database to be backuped to             File direct   new File Environment getExternalStorageDirectory       Exam Creator                    if  direct exists                                          if direct mkdir                                                      directory is created                                                         exportDB                importDB                     importing database         private void importDB                    TODO Auto-generated method stub              try                   File sd   Environment getExternalStorageDirectory                    File data    Environment getDataDirectory                     if  sd canWrite                          String  currentDBPath     data       PackageName                                   databases       DatabaseName                       String backupDBPath      BackupFolder DatabaseName                       File  backupDB  new File data  currentDBPath                       File currentDB    new File sd  backupDBPath                        FileChannel src   new FileInputStream currentDB  getChannel                        FileChannel dst   new FileOutputStream backupDB  getChannel                        dst transferFrom src  0  src size                         src close                        dst close                        Toast makeText getBaseContext    backupDB toString                                Toast LENGTH LONG  show                                     catch  Exception e                     Toast makeText getBaseContext    e toString    Toast LENGTH LONG                           show                                   exporting database          private void exportDB                    TODO Auto-generated method stub              try                   File sd   Environment getExternalStorageDirectory                    File data   Environment getDataDirectory                     if  sd canWrite                          String  currentDBPath     data       PackageName                                   databases       DatabaseName                       String backupDBPath      BackupFolder DatabaseName                       File currentDB   new File data  currentDBPath                       File backupDB   new File sd  backupDBPath                        FileChannel src   new FileInputStream currentDB  getChannel                        FileChannel dst   new FileOutputStream backupDB  getChannel                        dst transferFrom src  0  src size                         src close                        dst close                        Toast makeText getBaseContext    backupDB toString                                Toast LENGTH LONG  show                                     catch  Exception e                     Toast makeText getBaseContext    e toString    Toast LENGTH LONG                           show                                      Dont forget to add this permission to proceed it      lt uses-permission android name  android permission WRITE EXTERNAL STORAGE   gt       lt  uses-permission gt    Enjoy

[java] Simple export and import of a SQLite database on Android

Examples related to java

Examples related to android

Examples related to database

Examples related to sqlite