Remote database backup

Hi, I'm sharing a script to back up databases and send them to a remote server.

Respaldo remoto

Would be good to have English translation. Pasted it here https://github.com/NstAlarcon/respaldoremoto.sh/issues/1

I did not look into your script very well, but would it also be a good option to be able to make the backup of the database locally through such a script. And then for instance just download the backup through webmin from the backup directory.

It's also small enough to just paste directly here. Instead of a link.

README.md. translated and I share the script code here.

#!/bin/bash

set -e  # Stop execution if an error occurs

#Configuration
USER_DB="root"
PASSWORD_DB="password"
HOST_DB="localhost"
DB_NAME="databasename"
BACKUP_PATH="/backup"
REMOTE_USER="root"
REMOTE_HOST="REMOTE IP"
REMOTE_PORT="REMOTE PORT"
REMOTE_DIR="/root/backup"
DATE=$(date +"%d-%b-%Y")
BACKUP_FILE="$BACKUP_PATH/$DB_NAME-$DATE.sql"
REMOTE_FILE="$REMOTE_DIR/$DB_NAME-$DATE.sql"

#Ensure permissions
umask 177

#Check if the backup already exists locally
if [ -f "$BACKUP_FILE" ]; then
    echo "Backup $BACKUP_FILE already exists. Exiting..."
    exit 1
fi

#Start message
echo "Starting database backup for $DB_NAME..."

#Database dump
mysqldump --user=$USER_DB --password="$PASSWORD_DB" --host=$HOST_DB $DB_NAME > "$BACKUP_FILE"
echo "Backup completed: $BACKUP_FILE"

#Check if the backup already exists in the destination
if ssh -p $REMOTE_PORT "$REMOTE_USER@$REMOTE_HOST" "[ -f '$REMOTE_FILE' ]"; then
    echo "Backup $REMOTE_FILE already exists on the remote server. Exiting..."
    exit 1
fi

#Secure transfer to remote server
echo "Starting backup transfer to remote server..."
rsync -avz -e "ssh -p $REMOTE_PORT" "$BACKUP_FILE" "$REMOTE_USER@$REMOTE_HOST:$REMOTE_DIR/" --progress
echo "Transfer completed."

#Delete old backups locally (keep last 3)
echo "Deleting old backups locally..."
find "$BACKUP_PATH" -type f -name "$DB_NAME-*.sql" -mtime +2 -exec rm {} \;
echo "Old local backups deleted."

#Delete old backups on the remote server
echo "Deleting old backups on the remote server..."
ssh -p $REMOTE_PORT "$REMOTE_USER@$REMOTE_HOST" "find \"$REMOTE_DIR\" -type f -name '$DB_NAME-*.sql' -mtime +2 -exec rm {} \;"
echo "Old remote backups deleted."

echo "Process successfully completed."