chrisonline chrisonline - 1 year ago 352
Android Question

Backup and restore SQLite database to sdcard

How can I backup my database to the sdcard automatically in my app?
And afterward, how do I restore it?

Answer Source

Here is my code:

    // Local database
    InputStream input = new FileInputStream(from);

    // create directory for backup
    File dir = new File(DB_BACKUP_PATH);

    // Path to the external backup
    OutputStream output = new FileOutputStream(to);

    // transfer bytes from the Input File to the Output File
    byte[] buffer = new byte[1024];
    int length;
    while ((length =>0) {
        output.write(buffer, 0, length);

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download