Amazon Relational Database Service
User Guide (API Version 2012-01-15)
Print this pageEmail this pageGo to the ForumsView the PDFShare this page on TwitterShare this page on FacebookBookmark this page on DeliciousSubmit this page to RedditSubmit this page to DiggDid this page help you?  Yes  No   Tell us about it...

Restoring From a DB Snapshot

You must create a DB Snapshot before you can restore a DB Instance from one. When you restore the DB Instance, you provide the name of the DB Snapshot to restore from, and then provide a name for the new DB Instance that is created from the restore. You cannot restore from a DB Snapshot to an existing DB Instance; a new DB Instance is created when you restore.

[Note]Note

When you restore a DB Instance, only the default DB Parameter and DB Security Groups are applied. If you need custom DB Parameter or DB Security groups, you must apply them explicitly using the ModifyDBInstance API or the rds-modify-db-instance command line tool once the DB Instance is available.

In this example, you restore from a previously created DB Snapshot called mydbsnapshot and create a new DB Instance called mynewdbinstance.

AWS Management Console

To restore a DB Instance from a DB Snapshot

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. Click DB Snapshots in the Navigation list on the left side of the window.

  3. Click on the DB Snapshot that you want to restore from in the My DB Snapshots list.

  4. Click the Restore from DB Snapshot button.

    The Restore DB Instance window appears.

  5. Type the name of the restored DB Instance in the DB Instance Identifier text box.

  6. Click the Launch DB Instance button.

CLI

To restore a DB Instance from a DB Snapshot

  • Use the command rds-restore-db-instance-from-db-snapshot to restore a DB snapshot to a new DB instance.

    PROMPT>rds-restore-db-instance-from-db-snapshot mynewdbinstance -s mydbsnapshot

    This command returns output similar to the following:

    DBINSTANCE  mynewdbinstance  db.m1.large  MySQL     50       sa              creating  3  n  5.1.57  general-public-license					
    				

API

To restore a DB Instance from a DB Snapshot

  • Call RestoreDBInstanceFromDBSnapshot with the following parameters:

    • DBSnapshotIdentifier = mydbsnapshot

    • DBInstanceIdentifier = mynewdbinstance

    Example

    https://rds.amazon.com/
    	?Action=RestoreDBInstanceFromDBSnapshot
    	&DBSnapshotIdentifier=mydbsnapshot
    	&DBInstanceIdentifier=mynewdbinstance
    	&DBInstanceClass=db.m1.xlarge
    	&SignatureVersion=2
    	&SignatureMethod=HmacSHA256
    	&Timestamp=2009-10-15T17%3A48%3A21.746Z
    	&AWSAccessKeyId=<AWS Access Key ID>
    	&Signature=<Signature>