| # The directory where backups are stored | |
| BACKUP_DIRECTORY="/backups" | |
| echo "Backup process started." | |
| export MYSQL_USER="${MYSQL_USER}" | |
| export MYSQL_PASSWORD="${MYSQL_PASSWORD}" | |
| export MYSQL_DATABASE="${MYSQL_DATABASE}" | |
| # Save the current date in YYYY-MM-DD format to a variable | |
| current_datetime=$(date +%Y-%m-%d-%H%M%S) | |
| # Full path to the file | |
| backup_filename="${BACKUP_DIRECTORY}/backup-${current_datetime}.dump.gz" | |
| # Run mysqldump and compress its output, then save to /backups with the current date in the filename | |
| mysqldump -u "$MYSQL_USER" -p"$MYSQL_PASSWORD" "$MYSQL_DATABASE" | gzip > "$backup_filename" | |
| echo "Backup has been created and saved to ${backup_filename}" | |