How to take RDS DB backup on local computer.

Use below command to take backup on your local computer.

First of all install mysql on your system, then enter below command to take backup.

mysqldump --databases YourDBName -h HostOfYourRDSDB.us-west-2.rds.amazonaws.com -u DBUsername -P 3306 -p > rds.sql


Enter your password and wait for few minutes as it takes some time to load and download all data tables.

Note- This can take longer time to take backup if you have a big database.