The process follows a consistent loop, typically managed by a scheduled script (e.g., a Cron job):
- Dump: The script creates a dump/archive of your database.
- Compress & Prepare: It compresses the dump to save space and bandwidth.
- Authenticate: The script securely authenticates with Google Drive.
- Upload: It uploads the backup file to a specific folder in Google Drive.
- Cleanup (Optional): It deletes old local backup files to save disk space.
- Prune (Optional): It deletes old remote backups from Google Drive to stay within storage limits.
- Sleep & Repeat: The script waits for the next scheduled run.
