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

Upgrading a MySQL DB Snapshot

With Amazon RDS, you can create a storage volume DB snapshot of your MySQL DB instance. When you create a DB snapshot, the snapshot is based on the engine version used by your Amazon RDS instance. In addition to upgrading the DB engine version of your DB instance, you can also upgrade the engine version for your DB snapshots. For example, you can upgrade DB snapshots created from the MySQL 5.1 engine to DB snapshots for the MySQL 5.5 engine. After restoring a DB snapshot upgraded to a new engine version, you should test that the upgrade was successful. To learn how to test a major version upgrade, see Testing an Upgrade. To learn how to restore a DB snapshot, see Restoring From a DB Snapshot.

Amazon RDS supports upgrading a MySQL DB snapshot from MySQL 5.1 to MySQL 5.5.

Upgrading a MySQL DB Snapshot

You can upgrade manual DB snapshots, which can be encrypted or not encrypted, from MySQL 5.1 to MySQL 5.5 within the same region. You can't upgrade automated DB snapshots that are created during the automated backup process.

AWS Management Console

To upgrade 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, choose Snapshots.

  3. Choose Upgrade Snapshot. During the upgrade process, all snapshot actions except Upgrade Snapshot are disabled. Also, the DB snapshot status changes from available to upgrading, and then changes to active upon completion. If the DB snapshot can't be upgraded because of snapshot corruption issues, the status changes to unavailable. You can't recover the snapshot from this state.

    
                            MySQL Modify DB Snapshot

AWS CLI

To upgrade a DB snapshot to a new database engine version, use the AWS CLI modify-db-snapshot command.

Parameters

  • --db-snapshot-identifier – The identifier of the DB snapshot to upgrade. The identifier must be a unique Amazon Resource Name (ARN). For more information, see Working with Amazon Resource Names (ARNs) in Amazon RDS.

  • --engine-version – The engine version to upgrade the DB snapshot to.

Example

For Linux, OS X, or Unix:

Copy
aws rds modify-db-snapshot \ --db-snapshot-identifier <mydbsnapshot> \ --engine-version <new_version>

For Windows:

Copy
aws rds modify-db-snapshot ^ --db-snapshot-identifier <mydbsnapshot> ^ --engine-version <new_version>

API

To upgrade a DB snapshot to a new database engine version, call the Amazon RDS API ModifyDBSnapshot action.

  • DBSnapshotIdentifier – The identifier of the DB snapshot to upgrade. The identifier must be a unique Amazon Resource Name (ARN). For more information, see Working with Amazon Resource Names (ARNs) in Amazon RDS.

  • EngineVersion – The engine version to upgrade the DB snapshot to.

Example

Copy
https://rds.us-west-2.amazonaws.com/ ?Action=ModifyDBSnapshot &DBSnapshotIdentifier=mydbsnapshot &EngineVersion=newversion &SignatureVersion=4 &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20161222/us-west-1/rds/aws4_request &X-Amz-Date=20161222T233051Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=8052a76dfb18469393c5f0182cdab0ebc224a9c7c5c949155376c1c250fc7ec3

Related Topics