Create local copy of Amazon RDS Database

Question

How do I mysqldump the database on my AWS RDS instance to a .sql file for local use?

Answer 1

This is easy:

mysqldump -H <RDS_URL> -u <user> -p<password> <db> > myfile.sql

As long as you add the -H with proper user / password credentials, you'll have no problem.