#!/bin/sh

# how to use:
# ./backup.sh mysql_prod root rootpw mydb /var/log/backup.sql

# crontab example:
# 0 0 * * * /backup.sh mysql_prod root rootpw mydb /var/log/backup.sql

# restore example:
# cat backup.sql | docker exec -i [container_name] /usr/bin/mysql -u [mysql_user] --password=[mysql_password] [database_name]

set -uex

container_name=$1
mysql_user=$2
mysql_password=$3
db_name=$4
file_path=$5

if [ ! "$(docker ps | grep $container_name)" ]; then
        exit 1;
fi

docker exec $container_name /usr/bin/mysqldump -u root -p"$mysql_password" $db_name > $file_path