Hello I have a linux bastion host in AWS that I am able to SSH into. In the Bastion I am able to run a mysqldump command which makes a copy of an RDS instance. What I want to accomplish is being able to make a copy of a specific RDS snapshot. When I run the mysqldump command the copy is properly made but it returns the latest RDS data.
The original command I ran (which works) is something like:
mysqldump -u johnDoe -p -h my-rds-endpoint.rds.amazonaws.com --single-transaction <my-db-name> > /tmp/testData.sql
Is there a way to use this same command to return specific snapshot data. Sort of like:
mysqldump -u johnDoe -p -h <rds-snap-shot-arn-here> --single-transaction <my-db-name> > /tmp/testData.sql
Is this possibly using either the arn or the DB snapshot name?
Thank you.