How to export database from Amazon RDS MySQL instance to local instance?

July 6, 2021 . 1 MIN READ

To export db from RDS

mysqldump -h rds.host.name -u remote_user_name -p remote_db > remote_db.sql

When prompted for password, provide the password

To import db on RDS

mysql -h rds.host.name -u remote_user_name -p remote_db < remote_db.sql

When prompted for password, provide the password

Leave a Reply

Your email address will not be published. Required fields are marked *