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

Webmonger
  • 203
  • 2
  • 7

3 Answers3

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.

Webmonger
  • 203
  • 2
  • 7
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.

Paul R.
  • 1
  • 1
-1

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

You can use the S3Fox Firefox addon for this.

FrankPython
  • 199
  • 4
  • 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 http://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