# run docker from mysql:latest and mount volume explicitly
docker run -d \
    --name music-sql \
    -p 6033:3306 \
    -v /home/vplagov/docker/music-sql/:/var/lib/mysql \
    -e MYSQL_ALLOW_EMPTY_PASSWORD=yes \
    --restart always \
    mysql:latest


# create an empty database
# `<<<` means that part from the right will be passed to exec command as a stdin
docker exec \
    -i music-sql \
    mysql -u root \
    <<< "CREATE DATABASE music;"

# load dump file
docker exec \
    -i music-sql \
    mysql -u root --database=music \
    < ~/.mysql-backup/music.sql