docker mysql data volume_docker--数据持久化之Data Volume

最新推荐文章于 2023-12-08 20:27:58 发布

超级咨询师INFO

最新推荐文章于 2023-12-08 20:27:58 发布

阅读量292

点赞数

文章标签： docker mysql data volume

本文链接：https://blog.csdn.net/weixin_28741413/article/details/113280876

版权

[root@localhost ~]# docker exec -it mysql1 /bin/bash

root@31584edba6eb:/# mysql -uroot

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connectionid is 2Server version:5.7.26MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type'help;' or '\h' for help. Type '\c' to clearthe current input statement.

mysql>show databases;+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

+--------------------+

4 rows in set (0.00sec)

mysql>create database docker;

Query OK,1 row affected (0.00sec)

mysql>show databases;+--------------------+

| Database |

+--------------------+

| information_schema |

| docker |

| mysql |

| performance_schema |

| sys |

+--------------------+

5 rows in set (0.00sec)

mysql>exit

Bye

root@31584edba6eb:/# docker rm -f mysql1

bash: docker: command not found

root@31584edba6eb:/# exit

exit

[root@localhost~]# docker rm -f mysql1

INFO[2019-07-22T03:24:25.954289600-07:00] ignoring event module=libcontainerd namespace=moby topic=/tasks/delete type="*events.TaskDelete"WARN[2019-07-22T03:24:26.032476919-07:00] 31584edba6eb9b4aa772076f1c2d73c5eb7b4f1e62dd24b41c68518bdf62e11a cleanup: failed to unmount IPC: umount /var/lib/docker/containers/31584edba6eb9b4aa772076f1c2d73c5eb7b4f1e62dd24b41c68518bdf62e11a/mounts/shm, flags: 0x2: no such fileor directory

mysql1

[root@localhost~]# docker volume lsDRIVER VOLUME NAME

local mysql

[root@localhost~]# docker run -d --name mysql1 -v mysql:/var/lib/mysql --name mysql2 -e MYSQL_ALLOW_EMPTY_PASSWORD=true mysql:5.7.26877377cb64ec6242d2cd9e821d3978e7f5e6d2dce791d88e605e3f5b2a098762

[root@localhost~]# docker exec -it mysql2 /bin/bash

root@877377cb64ec:/# mysql -uroot

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connectionid is 2Server version:5.7.26MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type'help;' or '\h' for help. Type '\c' to clearthe current input statement.

mysql>show databases;+--------------------+

| Database |

+--------------------+

| information_schema |