RDS, export, mysqldump/ import

# 참조 : https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html

 

1) 두 데이타베이스로 원격 접속가능한 EC2 한대 필요. ( Function, Trigger, Event 덤프 필수 )

 

2.소스 db dump) /bin/mysqldump --routines --trigger --databases db1 db2 --single-transaction -r /mysqldump/dbdump.sql -h sourcedbserverip -u id -p password

 

3-1.타겟 db 접속) mysql -h targetdbserverip -u id -p password

 

3-2. source /mysqldump/dbdump.sql

 

끝 .