AWS: Making a copy of a database using RDS

0 votes
I have a database instance on RDS with 2 databases on it. Can we use the RDS command line tools to copy the one database to the other?
May 24, 2018 in Cloud Computing by code_ninja
• 6,220 points
28 views

1 answer to this question.

0 votes

One way to do that is mysqldump for getting the tables and mysql for import.

Or try setting up replication and then to promote the slave to be the master incase you want to update your database's release/version:

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

For external Backup:

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html

answered May 24, 2018 by DragonLord999
• 8,380 points

Related Questions In Cloud Computing

0 votes
2 answers

Is there a way to copy AMI from one AWS account to another AWS account using boto?

You could share the AMI from one ...READ MORE

answered Aug 21, 2018 in Cloud Computing by Priyaj
• 56,940 points
376 views
0 votes
1 answer

AWS: If EBS is Using RDS database can it be dropped?

EBS will run your software. It is ...READ MORE

answered May 23, 2018 in Cloud Computing by code_ninja
• 6,220 points
28 views
+3 votes
3 answers

Is there a way to install apache drill on an EMR cluster on AWS that is already Running?

It looks to be trying to get ...READ MORE

answered Oct 11, 2018 in Cloud Computing by findingbugs
• 4,750 points
335 views
+3 votes
3 answers

Is it possible to delete a API in AWS API Gateway?

Yes, it is possible to delete an ...READ MORE

answered Mar 27, 2018 in Cloud Computing by brat_1
• 7,080 points
708 views
+4 votes
2 answers

AWS Save & Share while using AWS Calculator

After doing your estimate, click the "Estimate ...READ MORE

answered Oct 11, 2018 in Cloud Computing by findingbugs
• 4,750 points
120 views
+3 votes
4 answers

Can AWS be used to Host a Website?

Yes! you can host a fully static ...READ MORE

answered Oct 16, 2018 in Cloud Computing by Peter S. Francis
65 views
+2 votes
3 answers

AWS S3 copy files and folders between two buckets

A simplified example using the aws-sdk gem: AWS.config(:access_key_id ...READ MORE

answered Aug 16, 2018 in Cloud Computing by Priyaj
• 56,940 points
804 views
+2 votes
2 answers

Is there a way to add cache control in AWS S3?

use of  current upstream master branch will ...READ MORE

answered Apr 10, 2018 in Cloud Computing by hemant
• 5,750 points
1,188 views
0 votes
2 answers

Maximizing value of max_connections in AWS RDS

Here is the Chart I made telling ...READ MORE

answered Aug 20, 2018 in Cloud Computing by Priyaj
• 56,940 points
350 views
0 votes
1 answer

AWS: Is there a way to simulate perimeter security using Amazon Web Services Model?

As we all know traditional perimeter security ...READ MORE

answered Jul 11, 2018 in Cloud Computing by DragonLord999
• 8,380 points
218 views