Backup schedule creates stale database dumps - no UI option to fix this

[herbertberanek-ops]

CloudPanel version(s) affected

v2.5.3

Description

Problem

I am not a developer. I set up Dropbox remote backup at 00:00 in CloudPanel UI.
I assumed the backup would contain a fresh database dump from that moment.

However, I discovered that CloudPanel creates the database dump separately
at 05:15 every day. This means every backup contains a database that is
almost 21 hours old at the time of backup.

This is a serious issue for anyone relying on these backups for disaster recovery.

What makes this worse

There is no way to change the database dump time through the CloudPanel UI.
The only solution is SSH access and manual cron editing — which is not
an option for non-developer users.

Expected behavior

Either:

1. The backup process should trigger a fresh database dump automatically
   before uploading to Dropbox/S3/SFTP, OR
2. The UI should allow users to configure when the database dump runs, OR
3. At minimum, the UI should clearly warn users that the backup will contain
   a database dump from a different time

Environment

• CloudPanel version: latest v2.5.3
• Backup destination: Dropbox
• OS: Ubuntu 24.04

How to reproduce

easy to reproduce

Possible Solution

No response

Additional Context

No response