#!/usr/bin/env bash
MYSQL_HOST="localhost"
MYSQL_USERNAME="msandbox"
MYSQL_SOCKET="/tmp/mysql_sandbox10121.sock"
MYSQL_PASSWORD="msandbox"
MYSQL_EXIT_STATUS=1
BACKUP_DATE=`date +'%Y-%m-%d_%H:%M'`
BACKUP_FILE=test.sql
BACKUP_DB=test

if [ ! -S $MYSQL_SOCKET ]; then
    echo "MySQL socket " $MYSQL_SOCKET "doesn't exist is mysql running?"
    exit
fi

mysqldump -h $MYSQL_HOST -S $MYSQL_SOCKET -u $MYSQL_USERNAME -p$MYSQL_PASSWORD $BACKUP_DB >$BACKUP_FILE
EXIT_STATUS=`echo $?`
if [[ $EXIT_STATUS -ne 0 ]]; then
    echo $BACKUP_DATE ": Backup command failed"
else
    echo $BACKUP_DATE ": Backup successfull"
    echo "Creating backup fingerpring"
    sha256sum $BACKUP_FILE >$BACKUP_FILE.sha
fi

# Verify that backup file has fingerpring of sha checksum
sha256sum --check $BACKUP_FILE.sha