Restore (DB Instance) from AWS Aurora RDS DB backup snapshot to existing DB Cluster

Question

We had a AWS Aurora MySQL RDS DB Cluster (say my-dbcluster) & DB Instance (say my-instance) setup. However due to some issue the DB instance got deleted. We do have backup at the cluster level and I could see those in AWS Console under my-dbcluster -> Maintenance & backups tab -> Snapshots section.

Based on the AWS documentation to Restore from DB snapshot, it should allow to create the DB instance by restoring from the DB snapshot. So on the AWS Console I went on to select the latest snapshot and try to Restore by providing the original DB Instance Identifier and other details. My expectation was that it will create the DB instance under the same DB Cluster (i.e. my-dbcluster) but it created altogether a new DB Cluster and created the DB instance under that. I tried to look for ways to move the DB Instance under the original DB cluster but could not find anything.

My question is, why it does not create/restore the DB Instance under the original DB Cluster, if this is not the default behavior, it should at least give an option to restore the DB instance under the DB Cluster of our choice. How can I achieve that.

Answer 1

Restoring to existing DB is not supported. From docs:

You can't restore from a DB cluster snapshot to an existing DB cluster; a new DB cluster is created when you restore.

You could use mysqldump to get data from your new cluster and import to existing one.