Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Creating a DB Snapshot

Amazon RDS creates a storage volume snapshot of your DB instance, backing up the entire DB instance and not just individual databases. Creating this DB snapshot on a Single-AZ DB instance results in a brief I/O suspension that typically lasting no more than a few minutes. Multi-AZ DB instances are not affected by this I/O suspension since the backup is taken on the standby.

When you create a DB snapshot, you need to identify which DB instance you are going to back up, and then give your DB snapshot a name so you can restore from it later.

In this example, you create a DB snapshot called mydbsnapshot for a DB instance called mydbinstance.

AWS Management Console

To create 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. In the navigation pane, click DB Instances.

  3. Click Instance Actions, and then click Take DB Snapshot.

    The Take DB Snapshot window appears.

  4. Type the name of the snapshot in the Snapshot Name text box.

    
							Console db snapshot edit db

  5. Click Yes, Take Snapshot.

CLI

To create a DB snapshot, use the AWS CLI create-db-snapshot command with the following parameters:

  • --db-instance-identifier

  • --db-snapshot-identifier

For Linux, OS X, or Unix:

Copy
aws rds create-db-snapshot / --db-instance-identifier mydbinstance / --db-snapshot-identifier mydbsnapshot

For Windows:

Copy
aws rds create-db-snapshot ^ --db-instance-identifier mydbinstance ^ --db-snapshot-identifier mydbsnapshot

The output from this command should look similar to the following:

Copy
DBSNAPSHOT mydbsnapshot mydbinstance 2009-10-21T01:54:49.521Z MySQL 50 creating sa 5.6.27 general-public-license

API

To create a DB snapshot, use the AWS CLI create-db-snapshot command with the following parameters:

  • DBInstanceIdentifier = mydbinstance

  • DBSnapshotIdentifier = mydbsnapshot

Example

Copy
https://rds.us-east-1.amazonaws.com/ ?Action=CreateDBSnapshot &DBInstanceIdentifier=mydbinstance &DBSnapshotIdentifier=mydbsnapshot &SignatureMethod=HmacSHA256 &SignatureVersion=4 &Version=2013-09-09 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20140423/us-east-1/rds/aws4_request &X-Amz-Date=20140423T161105Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=e9649af6edcfbab4016f04d72e1b7fc16d8734c37477afcf25b3def625484ed2

Related Topics