upload_db

#!/bin/bash

docker cp host/dump/blog.sql mysql_blog:/blog.sql
docker cp host/dump/blog_auth.sql mysql_auth:/blog_auth.sql
docker exec mysql_auth /bin/bash -c "mysql -u root --password=root --execute='DROP DATABASE IF EXISTS blog'"
docker exec mysql_blog /bin/bash -c "mysql -u root --password=root --execute='DROP DATABASE IF EXISTS blog'"
docker exec mysql_auth /bin/bash -c "mysql -u root --password=root --execute='CREATE DATABASE blog CHARACTER SET utf8 COLLATE utf8_unicode_ci'"
docker exec mysql_blog /bin/bash -c "mysql -u root --password=root --execute='CREATE DATABASE blog CHARACTER SET utf8 COLLATE utf8_unicode_ci'"
docker exec mysql_blog /bin/bash -c "mysql -u root --password=root --default-character-set=utf8 --comments --database=blog < /blog.sql"
docker exec mysql_auth /bin/bash -c "mysql -u root --password=root --default-character-set=utf8 --comments --database=blog < /blog_auth.sql"