Skip to content

Option to reuse last daily backup for weekly/monthly instead of new full dump #73

Description

@ouabira

Hi,

Weekly and monthly backups currently run a new full mysqldump, even though a full daily backup already exists. This causes long backup times and unnecessary CPU/IO load, especially with large databases.

Expected
Weekly and monthly backups should be able to reuse the latest daily backup instead of performing another full dump.

Proposal
Introduce config options such as:

  • WEEKLY_USE_LAST_DAILY=yes
  • MONTHLY_USE_LAST_DAILY=yes

This way, daily jobs still produce full dumps, while weekly/monthly simply copy/archive the latest daily.

Benefits

  • Faster weekly/monthly runs
  • Lower server load
  • Avoids redundant dumps

Thank you

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions