Download sql from rds to local
Command is simple.
mysqldump -h rds.host.name -u remote_user_name -p remote_db > dump.sql
Before excute this command, you have to check
rds security group. Your rds database have to allowpublic accessand add yourip addressformysqldumpyour sql file.
Upload sql to local
mysql -u local_user_name -p local_db < dump.sql
'tools > aws' 카테고리의 다른 글
| aws에 새로운 user 생성 이후 public key 추가하기 (0) | 2018.11.01 |
|---|---|
| AWS : upload folder to s3 with cli (0) | 2018.05.01 |
| AWS : copy file from aws ec2 to local (0) | 2018.04.20 |
| copy aws instance to other ec2 account (0) | 2017.12.10 |
| AWS cli 설치 및 s3 업로드, 다운로드하기 (0) | 2017.12.07 |