Flutter DB Backup While Using Sqflite

Question

I'm working on a flutter project. I want to extract and add the database for backup, but I haven't been able to do it for days. I'm thinking about how I can do this. I wonder if I can do this. Is this possible? If not, should I do it? If this is not possible when using SQLite, what should I use?

I tried everything but I couldn't do it. If anyone has a sample project, please share it with me.

Do you have a sample code or a resource where I can learn how to do it? — hizirley
– hizirley, Commented Dec 15, 2023 at 20:16

Brett Sutton · Accepted Answer · 2024-06-06 05:49:32Z

My understanding is that you just backup the files. The only trick to do this 'before' opening the database - as that locks the files.

Here is my backup script - note this won't work on web.

import 'dart:io';

import 'package:date_time_format/date_time_format.dart';

Future<void> backupDatabase(String pathToDatabase,
    {required int version}) async {
  final datePart =
      DateTimeFormat.format(DateTime.now(), format: 'Y.j.d.H.i.s');

  /// db file path with .bak and date/time/added
  final backupPath =
      '$pathToDatabase.$version.$datePart.bak';

  final dbFile = File(pathToDatabase);
  final backupFile = File(backupPath);


  if (dbFile.existsSync()) {
    await backupFile.writeAsBytes(await dbFile.readAsBytes());
    print('''
Database backup completed successfully: 
  Original Size: ${dbFile.lengthSync()}
  Backuped Size: ${backupFile.lengthSync()}
        ''');
  } else {
    print('Database file not found.');
  }
}

Collectives™ on Stack Overflow

Flutter DB Backup While Using Sqflite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related