Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an RDS database that I need to transfer a snapshot of to another AWS account. I understand there are issues being able to do this between availability zones so I'm really unsure if this is possible.

The RDS instance is mySql.

If it's not possible to transfer the snapshot please could you explain how to transfer the data from one RDS instance to another without downloading any if the contents(The DB is over 200GB).

Thanks in advance

share|improve this question
up vote 2 down vote accepted

We've decided that currently the only way to solve the problem is by creating a server in the second account and doing a database dump from mySQL to a mounted volume.

This can then be restored to the new RDS instance in the second account.

share|improve this answer
    
It seems that AWS make it very easy to get in but very hard to get out. – Programster Jan 21 '14 at 10:42

Amazon finally made it possible to accomplish this. I like to use AWS Tools for PowerShell to code it, but you can find equivalent commands in awscli or other SDKs.

You can share the snapshot with another account using the Edit-RDSDBSnapshotAttribute cmdlet (example here), then you can restore it to an account the snapshot was shared with using the Restore-RDSDBInstanceFromDBSnapshot cmdlet.

You can even share encrypted snapshots now. Here's a good walkthrough on how to do that.

share|improve this answer

We transfer AMI snapshots via S3, I guess the same works for RDS snapshots.

You can use the S3Fox Firefox addon for this.

share|improve this answer
    
Unfortunatley this will not work as RDS snapshots cant be accessed in the same way AMI snapshots are. Thanks for the idea. – Webmonger Jan 10 '11 at 13:07
    
Can you export it as a VM image to a local copy, and upload it to the other account as a image as well? check out aws.amazon.com/ec2/vmimport It is still in beta, so may or may not be able do work it with RDS, ask amazon i'd say – Flashman Jan 13 '11 at 19:26

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.