docker, MySQL 콘솔에서 정적 sql 파일 실행하는 법

[sangwonsheep]

docker sql 경로

docker exec -it techpick-mysql bash

bash-5.1# ls
afs  bin  boot	dev  docker-entrypoint-initdb.d  entrypoint.sh	etc  home  lib	lib64  media  mnt  opt	proc  root  run  sbin  srv  sys  tmp  usr  var

bash-5.1# cd var
bash-5.1# ls
adm  cache  db	empty  ftp  games  kerberos  lib  local  lock  log  mail  nis  opt  preserve  run  spool  tmp  yp

bash-5.1# cd lib
bash-5.1# ls
alternatives  dnf  games  misc	mysql  mysql-files  mysql-keyring  rpm	rpm-state  selinux  supportinfo

bash-5.1# cd mysql-files
bash-5.1# ls
create.sql  reset.sql

테이블 삭제, 추가 명령어

source /var/lib/mysql-files/reset.sql;
source /var/lib/mysql-files/create.sql;

[sangwonsheep]

aws, 홈 서버 모두 동일합니다.