tools/aws
AWS : dump mysql rds to local mysql
seul chan
2018. 4. 21. 16:34
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 access
and add yourip address
formysqldump
your sql file.
Upload sql to local
mysql -u local_user_name -p local_db < dump.sql