Export / backup db binary file on Android device? about sqlite HOT 8 CLOSED

I found that I can read DB raw data by:

const url = await db.getUrl();
  
  const file = await Filesystem.readFile({
    path: url.url!,
    encoding: Encoding.ASCII
  });

  const time = dateFormat('yyyy-MM-dd-HH-mm-ss');

  const r = await Filesystem.writeFile({
    path: `db/backup-${time}.db`,
    data: file.data,
    directory: Directory.Documents,
    recursive: true,
    encoding: Encoding.ASCII
  });

But after write to Documents and trying to read it by DB explorer, this file will corrupted and shows

Error encountered when performing Introspect schema main: [SQLITE_CORRUPT] The database disk image is malformed

Trying to compare it with the original db files in databases/, they are totally same file size, and same line numbers.

Any idea about deal this issue?

from sqlite.

I still not understand why read and write the db file will cause corrupted.

But finally I can read the db file if I use copy method. This is my solution:

const url = await db.getUrl();

  const time = dateFormat('yyyy-MM-dd-HH-mm-ss');

  const r = await Filesystem.copy({
    from: url.url!,
    to: `db/backup-${time}.db`,
    toDirectory: Directory.Documents
  });

from sqlite.

@asika32764 Are you on Android 13 API 33

from sqlite.

on simulator with Android 11 API 30

from sqlite.

@asika32764 thanks for this for me using copy is the best as it is a deep copy. May be it is due to the Encoding.ASCII may be it would have work with Encoding.UTF8. In my tutorials, can i use your suggestion if ones wants also to backup their database

from sqlite.

@asika32764 which is the application DB explorer that you are using in iOS and Android to read the database

from sqlite.

@asika32764 No news from you so i close it

from sqlite.

I'm using webstorm / phpstorm database reader.

I tried to compare 2 files but it seems they are same, I think maybe due to some difference in the file metadata.

from sqlite.