问题描述
我确定这是一个重复的主题，但我根本无法完成:我喜欢在运行时将我的数据库转储恢复到 MySQL 容器，而不修改 docker-compose.yml文件.
I'm sure this is a duplicated topic, but I simply cannot get it done: I like to restore my database dump to MySQL container in run time, without modifying the docker-compose.yml file.
Dockerfile
FROM php:5.4.45-apache
RUN apt-get update
RUN docker-php-ext-install mysql mysqli
docker-compose.yml
version: '2'
services:
php_service:
container_name: my_php
# Use Dockerfile in this dir to build the image
build: .
# Stop containers always after exiting.
restart: always
ports:
# 'localhost' does not works from the host, but the IP of docker itself
# (192.168.99.100 for example - shown on the top of the console)
- "80:80"
- "443:443"
environment:
# Pass variables
- API_TOKEN=xxxx
volumes:
# The current directory will be mounted to '/var/www/html'
# WORKS ONLY IN USER'S DIR ON WINDOWS (~/Downloads for example)
- .:/var/www/html
# See https://hub.docker.com/_/mysql/ for additional information.
# To open up console, run `docker exec -it my_mysql bash`.
# To restore a dump `docker exec -i my_mysql /usr/bin/mysql -u root
# --password=test_pass DATABASE < DUMP.sql` should work, but it never did.
mysql_service:
container_name: my_mysql
# Use an existing image
image: mysql:5.6
restart: always
ports:
# Let it accessible for other apps (mysql on host, IDE, etc.)
- "3306:3306"
environment:
MYSQL_ROOT_PASSWORD: 'test_pass' # TODO: Change this
MYSQL_USER: 'test'
MYSQL_PASS: 'pass'
volumes:
# Named volumes (my-datavolume) has to be listed in the "volumes"
# section - I don't know how it works or what is it doing at all...
# (-_-')
- my-datavolume:/var/lib/mysql
volumes:
my-datavolume:
重现步骤:
- 在 Windows 7 主机上启动 Docker Toolbox
docker-compose up- 打开一个新的 Docker Toolbox 终端
docker exec my_msql/usr/bin/mysql -u root --password=test_pass -e 'CREATE DATABASE testdb;'docker exec -i my_mysql/usr/bin/mysql -u root --password=test_pass testdbdocker exec -it my_mysql/usr/bin/mysql -u root --password=test_pass testdbmysql>显示表格；
数据库为空.似乎它什么也没做，因为终端响应太快了.我通过在我的主机上安装 MySQL 尝试了转储，它可以恢复.
The database is empty. It seems that it does nothing, because the terminal responds too quickly. I tried out the dump by installing MySQL on my host, it can be restored.
推荐答案
试试下面的命令对我来说很好.
Try below command works fine for me.
从 docker 主机运行它.
Run it from docker host machine.
备份
docker exec 容器/usr/bin/mysqldump -u root --password=root数据库 >备份.sql
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
恢复
猫备份.sql |docker exec -i CONTAINER/usr/bin/mysql -u root--password=root 数据库
Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root
--password=root DATABASE
如有任何问题，请告诉我.
Please let me know in case any issue.
这篇关于如何将 MySQL 转储从主机恢复到 Docker 容器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！