mysql -u root --host [host명(엔드포인트)] -P [포트번호] -p
ex)
mysql -u root --host with-you-camping.czqtqicux1bl.ap-northeast-2.rds.amazonaws.com -P 13306 -p
SET @tables = NULL;
SELECT GROUP_CONCAT(table_schema, '.', table_name) INTO @tables
FROM information_schema.tables
WHERE table_schema = 'DB이름 입력';
SET @tables = CONCAT('DROP TABLE ', @tables);
PREPARE stmt FROM @tables;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
bcrypt_lib.node: invalid ELF header
에러 발생version: "3"
services:
server:
build:
dockerfile: Dockerfile
context: ./
container_name: docker_server
restart: unless-stopped
ports:
- "8080:8080"
volumes:
- ./:/app
- /app/node_modules/
- /app/node_modules/bcrypt/
# 도커 컨테이너 실행 시
# package.json / script: "start": "NODE_ENV=production nodemon app.js " 수정
# docker-compose up 명령어 입력
.dockerignore
node_modules
Dockerfile
FROM node:16.13.0
WORKDIR /app
COPY ./package.json ./
RUN npm install
COPY ./ ./
CMD ["npm","run","start"]