MySQL Docker commands

docker.mysql

# Get MySQL CLI
docker exec -it <CONTAINER> sh -c 'mysql -u${MYSQL_USER} --password=${MYSQL_PASSWORD}'

# Run SQL script
cp my.sql /path/to/mysql/volume
docker exec <CONTAINER> sh -c 'mysql -u${MYSQL_USER} --password=${MYSQL_PASSWORD} $MYSQL_DATABASE < /var/lib/mysql/my.sql'

# Backup MySQL database
docker exec <CONTAINER> sh -c 'exec mysqldump -u${MYSQL_USER} --password=${MYSQL_PASSWORD} $MYSQL_DATABASE' > my.backup.sql