CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-rds
Janier
Janier

Reputation: 4412

how to clone and create a new database in RDS MySql

I want to create a new database with the contents of the existing database. It's like cloning the existing database and making a new one. This is for a switchover purpose.

How to do it in RDS MySQL?

Upvotes: 3

Views: 3275

Answers (1)

neildt
neildt

Reputation: 5352

The best way to clone an RDS instance is to create a snapshot of your instance (or use an existing snapshot) then restore that snapshot into a new instance.

For more information visit https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html

When you restore the DB instance, you provide the name of the DB snapshot to restore from, and then provide a name for the new DB instance that is created from the restore. You cannot restore from a DB snapshot to an existing DB instance; a new DB instance is created when you restore.

Upvotes: 5

Related Questions