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,300 points
520 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,450 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
• 58,020 points
2,257 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 24, 2018 in Cloud Computing by code_ninja
• 6,300 points
993 views
0 votes
0 answers

what are the benefits of using aws organizations

Dec 15, 2023 in Cloud Computing by Priyanka
• 4,080 points
217 views
0 votes
1 answer

what is a benefit of using cloud computing in networking

Unmatched scalability and flexibility are provided by ...READ MORE

answered Mar 1 in Cloud Computing by Chiranjeev Choudhary
310 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,780 points
2,397 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,200 points
4,768 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,780 points
1,812 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
• 58,020 points
4,785 views
0 votes
3 answers

Maximizing value of max_connections in AWS RDS

AWS RDS Max Connections Limit As Per ...READ MORE

answered Jul 24, 2020 in Cloud Computing by Sagar
4,779 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,450 points
1,275 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP