인프런 커뮤니티 질문&답변

강의처럼 myDB라는 DB를 만들고 컨테이너 삭제 후, 다시 실행했을때 그 DB가 남아있는지 확인해봤는데 안남아있네요.
아래의 로그는 제가 했을때의 로그입니다!

d----- 2025-04-06 오후 11:25 docker-mysql

PS C:\Users\icb16\dockervolume> cd docker-mysql

PS C:\Users\icb16\dockervolume\docker-mysql> docker run -e MYSQL_ROOT_PASSWORD=password123 -v C:\Users\icb16\dockervolume\docker-mysql -d mysql

24f951c78cbf0dab6bea6b4b8deaf8f29781ae613b3cad782bbf569e44acbda3

PS C:\Users\icb16\dockervolume\docker-mysql> docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

24f951c78cbf mysql "docker-entrypoint.s…" 12 seconds ago Up 11 seconds 3306/tcp, 33060/tcp optimistic_elion

PS C:\Users\icb16\dockervolume\docker-mysql> docker rm -f 24f951

24f951

PS C:\Users\icb16\dockervolume\docker-mysql> docker run -e MYSQL_ROOT_PASSWORD=password123 -d -p 3306:3306 -v C:\Users\icb16\dockervolume\docker-mysql\mysql_data:\var\lib\mysql -d mysql

068022ff288d2e9b7a4605e1da688688a43a14c9e0c1d31041d86067466d62a2

PS C:\Users\icb16\dockervolume\docker-mysql> docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

068022ff288d mysql "docker-entrypoint.s…" 3 minutes ago Up 3 minutes 0.0.0.0:3306->3306/tcp, 33060/tcp friendly_hypatia

PS C:\Users\icb16\dockervolume\docker-mysql> docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

068022ff288d mysql "docker-entrypoint.s…" 5 minutes ago Up 5 minutes 0.0.0.0:3306->3306/tcp, 33060/tcp friendly_hypatia

PS C:\Users\icb16\dockervolume\docker-mysql> docker exec -it 0680

docker: 'docker exec' requires at least 2 arguments

Usage: docker exec [OPTIONS] CONTAINER COMMAND [ARG...]

See 'docker exec --help' for more information

PS C:\Users\icb16\dockervolume\docker-mysql> docker exec -it 0680 bash

bash-5.1# ls

'\var\lib\mysql' bin dev etc lib media opt root sbin sys usr

afs boot docker-entrypoint-initdb.d home lib64 mnt proc run srv tmp var

bash-5.1# mysql -u root -p

Enter password:

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

Your MySQL connection id is 9

Server version: 9.2.0 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

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 clear the current input statement.

mysql> show databases

-> ;

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

| Database |

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

| information_schema |

| mysql |

| performance_schema |

| sys |

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

4 rows in set (0.01 sec)

mysql> create database myDB

-> ;

Query OK, 1 row affected (0.01 sec)

mysql> show databases;

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

| Database |

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

| information_schema |

| myDB |

| mysql |

| performance_schema |

| sys |

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

5 rows in set (0.00 sec)

mysql> ^C

mysql> ^C

mysql> ^C

mysql> exit

Bye

bash-5.1# exit

exit

PS C:\Users\icb16\dockervolume\docker-mysql> docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

068022ff288d mysql "docker-entrypoint.s…" 6 minutes ago Up 6 minutes 0.0.0.0:3306->3306/tcp, 33060/tcp friendly_hypatia

PS C:\Users\icb16\dockervolume\docker-mysql> docker rm -f 068

068

PS C:\Users\icb16\dockervolume\docker-mysql> docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

PS C:\Users\icb16\dockervolume\docker-mysql> docker run -e MYSQL_ROOT_PASSWORD=password123 -d -p 3306:3306 -v C:\Users\icb16\dockervolume\docker-mysql\mysql_data:\var\lib\mysql -d mysql

dcb75ed6d3fab0a0a320869e7728179f58299ec0e43b948408c599e8c9ecf089

PS C:\Users\icb16\dockervolume\docker-mysql> docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

dcb75ed6d3fa mysql "docker-entrypoint.s…" 14 seconds ago Up 13 seconds 0.0.0.0:3306->3306/tcp, 33060/tcp zealous_spence

PS C:\Users\icb16\dockervolume\docker-mysql> docker exec -it dcb7

docker: 'docker exec' requires at least 2 arguments

Usage: docker exec [OPTIONS] CONTAINER COMMAND [ARG...]

See 'docker exec --help' for more information

PS C:\Users\icb16\dockervolume\docker-mysql> docker exec -it dcb7 bash

bash-5.1# mysql -u root -p

Enter password:

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

Your MySQL connection id is 9

Server version: 9.2.0 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

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 clear the current input statement.

mysql> show databases

-> ;

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

| Database |

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

| information_schema |

| mysql |

| performance_schema |

| sys |

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

4 rows in set (0.00 sec)

mysql>