Unable to do mysqldump to AWS RDS


Staff member
I'm trying to export an existing MySQL DB from an AWS EC2 instance to RDS using mysqldump. Here's my syntax:

mysqldump wordpress-db | mysql --host= --port=3306 --user= --password wordpress-db

...where wordpress-db is an existing MySQL DB on my EC2 instance and wordpress-db is also the name of the RDS DB (the endpoint begins with "wordpress-db").

The error message is:

ERROR 1049 (42000): Unknown database 'wordpress-db'
Both the EC2 instance and RDS DB are in the same region...

I'm a bit new to RDS so there's probably something obvious I'm doing wrong. Any ideas?