mysqldump.sh

#!/bin/bash

FILE=/home/ubuntu/mysql_backup/mysql-credentials.cnf
if [ -f "$FILE" ]; then
    echo "$FILE exists."
    rm $FILE
else 
    echo "$FILE does not exist."
fi
credentialsFile=/home/ubuntu/mysql_backup/mysql-credentials.cnf
echo "[client]" > $credentialsFile
echo "user=root" >> $credentialsFile
echo "password=XXXXXXXXXX" >> $credentialsFile
echo "host=localhost" >> $credentialsFile

#COPYING THE FILE inside the docker container
docker cp $FILE mysql:/
docker exec -it mysql mysqldump --defaults-extra-file=/mysql-credentials.cnf --all-databases > all_databases-$(date +%Y%m%d).sql

#COPY THE MYSQL BACKUP TO S3
aws s3 cp /home/ubuntu/mysql_backup/all_databases-$(date +%Y%m%d).sql s3://test-bucket/backup/Demo/mysql-backup/all_databases-$(date +%Y%m%d).sql