Take Aurora MySQL Database Connection and restore it into another instance.

Question

I want to take Aurora MySQL database snapshot or backup of an instance (not complete instance snap) and restore it in an already working instance which already have 2 database running. The 2 database already created should not be effected and just anther db is restored in the instance so total of 3 db in that instance after restore. Engine verison 8.0.mysql_aurora.3.02.2

Answer

You would have to go old school and backup and restore the database using tools like mysqldump

Or use AWS DMS to copy a Database from one instance to another

Answer

You could use mydumper and myloader to export/import a single database.

See reference documentation [here](https://docs.aws.amazon.com/whitepapers/latest/amazon-aurora-mysql-migration-handbook/multi-threaded-migration-using-mydumper-and-myloader.html).

Take Aurora MySQL Database Connection and restore it into another instance.

Relevant content