Copy database from assets to Device SD Card , removes data in the tables

Question

I'm coping a database from assets folder to my Device Sd Card using this code

private void copyDataBase() throws IOException {
        try {

            InputStream mInputStream = mContext.getAssets().open(DB_NAME);

            String outFileName = DB_PATH + DB_NAME;



            OutputStream mOutputStream = new FileOutputStream(outFileName);

            byte[] buffer = new byte[1024];
            int length;

            while ((length = mInputStream.read(buffer)) > 0) {
                mOutputStream.write(buffer, 0, length);
            }

            mOutputStream.flush();
            mOutputStream.close();
            mInputStream.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

it works fine and copies the database to my devices desired folder , but when I check the data in the tables , all the data are gone , tables are empty , I've searched in Stack to get a satisfactory idea , or answer , but they were all about how to copy , any idea?

Answer 1

I'm doing this right now and it's working..so I share my code..maybe this would help you.

File file = new File(Environment.getExternalStorageDirectory(), "my.db");

InputStream  in  = null;
OutputStream out = null;
try {
    in  = getAssets().open("my.db"); //.I'm in a service, so I don't need context
    out = new FileOutputStream(file);

    int count = 0; 
    byte[] buffer = new byte[1024*4];
    while ((count = in.read(buffer)) != -1) {
       out.write(buffer, 0, count);
       out.flush();
    }
 } catch (IOException err) {
    Log.e(TAG, err.getMessage(), err);

 } finally {
   if (in != null) 
      try { in.close(); } 
      catch (IOException ignore) {  }
   if (out != null) 
      try { out.close(); } 
      catch (IOException ignore) {  }
 }

Edit 1

Here the SQLiteOpenHelper code

public class SchemaHelper extends SQLiteOpenHelper {

    static final private String DATABASE_NAME = "my.db";
    static final private int DATABASE_VERSION = 1;  

    private SchemaHelper( Context context ) {
       super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate( SQLiteDatabase db ) {
       /* The database has 6 tables pre-populated */
       /* This one is the only created at runtime */
       /* and editable by the user */
       ShoppingListTable.onCreate(db);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
       /* The database has 6 tables pre-populated */
       /* This one is the only created at runtime */
       /* and editable by the user */
       ShoppingListTable.onUpgrade(db, oldVersion, newVersion);
    }
}

Edit 2

ShoppingListTable is an helper static class which define the column fields and the creation/upgrade. This is the only Table created at runtime, all the others are pre-created and pre-filled.

public class ShoppingListTable {

   static final public String COLUMN_PRODUCT_ID = BaseColumns._ID;
   static final public String COLUMN_PARSE_OBJECT_ID = "objectId";
   static final public String COLUMN_LAST_UPDATE = "lastUpdate";
   static final public String TABLE_NAME = "ShoppingList";

   static 
   public void onCreate(SQLiteDatabase database) {
      StringBuilder sql = new StringBuilder();
      sql.append("CREATE TABLE ").append(TABLE_NAME).append(" (");
      sql.append(COLUMN_PRODUCT_ID).append(" INTEGER PRIMARY KEY NOT NULL, ");
      sql.append(COLUMN_PARSE_OBJECT_ID).append(" TEXT, ");
      sql.append(COLUMN_LAST_UPDATE).append(" INTEGER DEFAULT -1, ");
      sql.append(COLUMN_SYNCSTATE).append(" INTEGER DEFAULT 0 ");
      sql.append(");");

      database.execSQL(sql.toString());
   }

   static
   public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
      Log.w( ShoppingListTable.class.getName(), "Upgrading database from version "
         + oldVersion + " to " + newVersion + ", which will destroy all old data" );
      database.execSQL("DROP TABLE IF EXISTS " + ShoppingListTable.TABLE_NAME );
      ShoppingListTable.onCreate(database);
   }
}

Answer 2

try this. This work for me...

String outFileName = "/data/data/" + ctx.getPackageName() + "/databases/YOUR_DB";

Preinitialized DB should not have any file extension. Hope this helps you

Answer 3

Try to use Buffered Stream as mentioned below with proper while condition and try..catch.

BufferedInputStream in = new BufferedInputStream(new FileInputStream(fromFileName));
BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream(toFileName));
byte[] buff = new byte[1024];
int len;
try{
while ((len = in.read(buff,0,buff.lenght())) > 0){
  out.write(buff, 0, len);
}
}catch(Exception e){
  e.printStackTrace()
}
out.flush();    
out.close();
in.close();

Answer 4

DB file shoud be

static File DB_FILE = context.getDatabasePath("databasename");

If your database is larger than 1MiB you have to split it into chunks

Check my answer here

Getting “Failed to open database” error when copying a sqlite database from assets In Android 4.2

Also you can take a look here

Load files bigger than 1M from assets folder