LeEnot

Note that normally an application is not allowed to commit fragment transactions while in this call, since it can happen after an activity's state is saved. See FragmentManager.openTransaction() for further discussion on this.

private String loadSpinnerBaudrateData() {
        String selected;
        baudrate = new ArrayList<String>();
        Cursor baudrateCursor = database.query(TABLE_NAME,
                new String[]{BAUDRATE_ID, BAUDRATE_NAME, BAUDRATE_SELECTED},
                null, null, null, null,
                BAUDRATE_NAME);
        baudrateCursor.moveToFirst();
        if (!baudrateCursor.isAfterLast()) {
            do {
                String name = baudrateCursor.getString(1);
                if (baudrateCursor.getInt(baudrateCursor.getColumnIndex( BAUDRATE_SELECTED )) == 1){
                      selected = name;
                }
                baudrate.add(name);
            } while (baudrateCursor.moveToNext());
        }
        baudrateCursor.close();
        database.close();   // Закрываем БД
        return selected;
    }

String compareValue = loadSpinnerBaudrateData();
int spinnerPosition = BaudratedataAdapter.getPosition(compareValue);
BaudrateSpinner.setSelection(spinnerPosition);

public void exportDatabse(String databaseName) {
        try {
            File sd = Environment.getExternalStorageDirectory();
            File data = Environment.getDataDirectory();

            if (sd.canWrite()) {
                String currentDBPath = "//data//"+getPackageName()+"//databases//"+databaseName+"";
                String backupDBPath = "backupname.db";
                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) {

        }
    }

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