MYSQL

[linguo@VM-4-6-centos logs]$ docker pull mysql:5.7
[linguo@VM-4-6-centos logs]$  docker run -p 3306:3306 --name mysql5.7 -v /home/linguo/mysql5.7/conf:/etc/mysql/conf.d -v /home/linguo/mysql5.7/logs:/logs -v /home/linguo/mysql5.7/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
[linguo@VM-4-6-centos logs]$ docker ps
CONTAINER ID   IMAGE          COMMAND                  CREATED         STATUS         PORTS                                                  NAMES
be5591d3e47c   mysql:5.7      "docker-entrypoint.s…"   4 seconds ago   Up 2 seconds   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql5.7
[linguo@VM-4-6-centos logs]$ docker exec -it be5591d3e47c /bin/bash
[linguo@VM-4-6-centos ~]$  docker exec be5591d3e47c mysqldump --all-databases -uroot -p123456 > /home/linguo/mysql_callback_data.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
[linguo@VM-4-6-centos ~]$ ll
drwxr-xr-x 5 root   root      4096 Apr 25 23:39 mysql5.7
-rw-rw-r-- 1 linguo linguo 3573621 Apr 26 00:12 mysql_callback_data.sql

docker run
-p 3306:3306 指定宿主机映射端口
—name mysql5.7命名容器
-v /home/linguo/mysql5.7/conf:/etc/mysql/conf.d 同步配置文件
-v /home/linguo/mysql5.7/logs:/logs 同步日志
-v /home/linguo/mysql5.7/data:/var/lib/mysql 同步数据文件
-e MYSQL_ROOT_PASSWORD=123456 初始化mysql密码
-d mysql:5.7 以守护式运行mysql5.7

mysqldump 数据库备份