[강의정리] AWS - 서버 연결 + 덤프

1.# mariadb 실행

docker run -d --name mariadb -p 3306:3306 -e MYSQL_ROOT_PASSWORD=gudi@gdj63 -v /home/ec2-user/db:/var/lib/mysql mariadb

gudi@gdj63

2.# db 접속 후 계정 생성

# db 접속 후 계정 생성
create user 'web_user'@'%' IDENTIFIED BY 'gdj63@pass';

<beans:bean name="datasource" class="org.apache.commons.dbcp.BasicDataSource">
<beans:property name="driverClassName" value="org.mariadb.jdbc.Driver"/>
<beans:property name="url" value="jdbc:mariadb://3.137.214.184:3306/db"/>
<beans:property name="username" value="web_user"/>
<beans:property name="password" value="gdj63@pass"/>

 

3.# db 덤프

덤프 뜨기

 

mysqldump -u root -p mydb > C:\Users\GDJ63\mydb.sql

 

 

덤프 받기

 

mysql -u root -p mydb < C:/Users/nagyeongyoung/mydb.sql