How to export data from AWS RDS MySQL database and import to an other AWS RDS MySQL database instance

Question

I am looking for the best way to export data from one MySQL DB instance of RDS an import into a different one automatically.

Any ideas?

Answer 1

A simple way of copy an entire database is to create a read replica of the original and promote this read replica into a separate database.