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

Example

For Linux, OS X, or Unix:

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

For Windows:

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

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

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

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