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.

Answer 2

Or you can use a client like MySQL Work Bench to open it remotely and export it to .sql anytime you feel like.

http://www.mysql.com/products/workbench/