MySQL Backup Script

mysql_backup.sh

#!/bin/bash

# Usage: ./script.sh <username> <password> <host> <port> <target-folder (optional)>
# Example: ./script.sh admin admin 127.0.0.1 3306 /var/backups/mysql
# Default dump folder is /var/backups/mysql

if [ -z "$1" ]; then
    echo "The usage is: <username> <password> <host> <port> <target-folder (optional)>";
    exit;
elif [ -z "$2" ]; then
    echo "[ERROR] MySQL connection 'password' is not provided";
    exit;
elif [ -z "$3" ]; then
    echo "[ERROR] MySQL connection 'host' is not provided";
    exit;
elif [ -z "$4" ]; then
    echo "[ERROR] MySQL connection 'port' is not provided";
    exit;
fi;

CLI_LIST="mysql mysqldump";

for CLI in $CLI_LIST; do
    if ! command -v $CLI >/dev/null 2>&1; then
        echo "'$CLI' is not found";
        exit;
    fi;
done

DESIRED_TARGET_FOLDER="$5";

if [ -z "$DESIRED_TARGET_FOLDER" ]; then
    DESIRED_TARGET_FOLDER="/var/backups/mysql";
elif [[ "$DESIRED_TARGET_FOLDER" == */ ]]; then
    echo "[ERROR] The desired target folder should not end with /";
    exit;
fi;

CURRENT_DATE="$(date +"%H").$(date +"%M").$(date +"%S")-$(date +%F)"
TARGET_FOLDER="$DESIRED_TARGET_FOLDER/$CURRENT_DATE"

mkdir -p $TARGET_FOLDER;

echo "[DEBUG] Creating MySQL dump folder on $TARGET_FOLDER";
echo "[DEBUG] Running MySQL backup for Host '$3' on Port '$4' using Username '$1'";

MYSQL_CONNECTION_CONFIG="-u '$1' -p$2 -h $3 -P $4";
DATABASES=`mysql $MYSQL_CONNECTION_CONFIG -e "show databases" | sed -n '2,$ p'`;

for DATABASE in $DATABASES; do
    { #try
        echo "[DEBUG] Creating SQL file from database '$DATABASE' on $TARGET_FOLDER/$DATABASE.sql";
        mysqldump $MYSQL_CONNECTION_CONFIG $DATABASE > $TARGET_FOLDER/$DATABASE.sql;
    } || { #catch
        echo "[ERROR] Failed to create SQL file from database '$DATABASE'"
    }
done