Backup and restore a MySQL database from a running Docker MySQL container

mysql-backup.sh

#!/bin/sh

CONTAINER="CONTAINER"
USER="USER"
PASSWORD="PASSWORD"
DATABASE="DATABASE"
FILE="backup.sql"

echo "User: $USER"
if [ -n "$PASSWORD" ]
then
  echo "Using password: YES"
else
  echo "Using password: NO"
fi
echo "Database: $DATABASE"
echo "Backing up database..."

if
  docker exec $CONTAINER /usr/bin/mysqldump -u $USER --password=$PASSWORD $DATABASE > $FILE
then
  echo "Successfully backed-up the database into $FILE."
else
  echo "Database backup failed."
fi

mysql-restore.sh

#!/bin/sh

CONTAINER="CONTAINER"
USER="USER"
PASSWORD="PASSWORD"
DATABASE="DATABASE"
FILE="backup.sql"

echo "Container: $CONTAINER"
echo "User: $USER"
if [ -n "$PASSWORD" ]
then
  echo "Using password: YES"
else
  echo "Using password: NO"
fi
echo "Database: $DATABASE"
echo "Restoring database..."

if
  cat $FILE | docker exec -i $CONTAINER /usr/bin/mysql -u $USER --password=$PASSWORD $DATABASE
then
  echo "Successfully restored the database from $FILE."
else
  echo "Database restore failed."
fi