Get app sqlite database programmatically in file

Question

I want to upload my sqlite DB file to DropBox. But before that I need to get the sqlite Db file in code. How can I do this on any device? I checked on this link, and it says that the user needs root permissions to access the database.

So in short:

How can I access my sqlite database with non rooted devices? eg File f = new File("path_to_db_file");

If that approach is impossible, how can I save my app database in a place that I will be able to gain access to it?

Please let me know if I can explain anything. Thank you in advance

Programmatically create sqlite on SD's folder then you will not require to root your device. If you have already created an sqlite database then if you have limited tables then create a code that will read values from these tables and create a copy of them on another location of SD-card. — Lucifer
– Lucifer, Commented Apr 14, 2014 at 9:23
@Kedarnath Thank you for commenting, do you know how to create a database at a specified location? At the moment my DB class is extending SQLiteOpenHelper — user3524019
– user3524019, Commented Apr 14, 2014 at 9:35

Izuel · Accepted Answer · 2014-04-14 10:50:15Z

2

Yes you can, something like this worked for me without root permission:

File Db = new File("/data/data/your.package/databases/yourdatabasename");        
Date d = new Date();         

File file = new File("your_destination.db");
file.setWritable(true);

copyFile(new FileInputStream(Db), new FileOutputStream(file));

Copy file is a function like this, and works in both directions DB->File and File->DB:

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();
            }
        }
    }
}

answered Apr 14, 2014 at 10:50

Izuel

4526 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user3524019 Over a year ago

Are you sure your device is not rooted? I get a file not found exception every time I try your solution

Izuel Over a year ago

I'm a lazy guy so I don't have any device rooted for sure because the process sometimes has a lot of steps. Could be that the path to your database is not the correct one? You can get the path with the next line: context.getDatabasePath(DB_NAME).toString();

user3524019 Over a year ago

Thank you for the suggestion, I already tried that though, I'm just getting the FileNotFound exception, fail

Chetan Chaudhari Over a year ago

FileNotFoundException you are getting because your_destination.db is not present. Add the below code and check File file = new File(your_destination.db); //if file was created earlier the delete the old file if (file.exists()) { file.delete(); } //create new file file.createNewFile(); file.setWritable(true);

Santosh Bangar · Accepted Answer · 2017-02-08 13:11:32Z

0

I don't know about programmatically but using Rooted Device we can get database from device for that we have to did permission to your app as a Superuser and copy from your app package name and past to your sd card and Access.

answered Feb 8, 2017 at 13:11

Santosh Bangar

581 silver badge8 bronze badges

Comments

Chetan Chaudhari · Accepted Answer · 2021-02-11 05:36:50Z

0

Working code sample

try {

 File Db = new File("/data/data/your.package/databases/yourdatabasename");        
 Date d = new Date();         

 File file = new File(your_destination.db);

  //if file was created earlier the delete the old file
  if (file.exists()) {
      file.delete();
  }
  
   //create new file
  file.createNewFile();
  file.setWritable(true);

 copyFile(new FileInputStream(Db), new FileOutputStream(file));

}catch (Exception e) {
        e.printStackTrace();
}

answered Feb 11, 2021 at 5:36

Chetan Chaudhari

3235 silver badges15 bronze badges

Collectives™ on Stack Overflow

Get app sqlite database programmatically in file

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related