Daily Full Website Backup Setup

I need a reliable, fully automated backup solution that captures my entire website—both the files and the MySQL database—on a daily schedule. Each run should create two copies: one saved locally on the server for quick restores and another pushed to cloud storage such as Google Drive or Dropbox for off-site safety.

The outcome I expect is:
• A script or panel configuration that zips the full site and dumps the database in a single archive, runs every 24 hours, and cleans up old versions according to a rolling retention policy we agree on.
• Seamless transfer of the remote copy to my chosen cloud account, using secure methods (Rclone, API, or similar).
• A brief test restore performed once so we can confirm the procedure works end to end.
• Simple instructions so I can adjust paths, credentials, or timing later without needing to touch the code.

You are free to work with standard tools—cron, bash, PowerShell, cPanel backups, mysqldump, rsync, etc.—as long as everything remains platform-agnostic and easy to maintain. If you prefer a lightweight backup utility or WordPress plugin, let me know; I am open as long as it meets the daily schedule and dual-destination requirement.

Please outline how you would approach the task and the estimated time to deliver the first successful backup run.