6

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

3 Answers 3

2

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.

1
  • It seems that AWS make it very easy to get in but very hard to get out. Jan 21, 2014 at 10:42
0

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.

-1

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

You can use the S3Fox Firefox addon for this.

2
  • 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, 2011 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, 2011 at 19:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .