Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Performing a backtrack for an Aurora MySQL DB cluster - Amazon Aurora

Performing a backtrack for an Aurora MySQL DB cluster

You can backtrack a DB cluster to a specified backtrack time stamp. If the backtrack time stamp isn't earlier than the earliest possible backtrack time, and isn't in the future, the DB cluster is backtracked to that time stamp.

Otherwise, an error typically occurs. Also, if you try to backtrack a DB cluster for which binary logging is enabled, an error typically occurs unless you've chosen to force the backtrack to occur. Forcing a backtrack to occur can interfere with other operations that use binary logging.

Important

Backtracking doesn't generate binlog entries for the changes that it makes. If you have binary logging enabled for the DB cluster, backtracking might not be compatible with your binlog implementation.

Note

For database clones, you can't backtrack the DB cluster earlier than the date and time when the clone was created. For more information about database cloning, see Cloning a volume for an Amazon Aurora DB cluster.

The following procedure describes how to perform a backtrack operation for a DB cluster using the console.

To perform a backtrack operation using the console
  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 Instances.

  3. Choose the primary instance for the DB cluster that you want to backtrack.

  4. For Actions, choose Backtrack DB cluster.

  5. On the Backtrack DB cluster page, enter the backtrack time stamp to backtrack the DB cluster to.

    Backtrack DB cluster
  6. Choose Backtrack DB cluster.

Console

The following procedure describes how to perform a backtrack operation for a DB cluster using the console.

To perform a backtrack operation using the console
  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 Instances.

  3. Choose the primary instance for the DB cluster that you want to backtrack.

  4. For Actions, choose Backtrack DB cluster.

  5. On the Backtrack DB cluster page, enter the backtrack time stamp to backtrack the DB cluster to.

    Backtrack DB cluster
  6. Choose Backtrack DB cluster.

The following procedure describes how to backtrack a DB cluster using the AWS CLI.

To backtrack a DB cluster using the AWS CLI
  • Call the backtrack-db-cluster AWS CLI command and supply the following values:

    • --db-cluster-identifier – The name of the DB cluster.

    • --backtrack-to – The backtrack time stamp to backtrack the DB cluster to, specified in ISO 8601 format.

    The following example backtracks the DB cluster sample-cluster to March 19, 2018, at 10 a.m.

    For Linux, macOS, or Unix:

    aws rds backtrack-db-cluster \ --db-cluster-identifier sample-cluster \ --backtrack-to 2018-03-19T10:00:00+00:00

    For Windows:

    aws rds backtrack-db-cluster ^ --db-cluster-identifier sample-cluster ^ --backtrack-to 2018-03-19T10:00:00+00:00

The following procedure describes how to backtrack a DB cluster using the AWS CLI.

To backtrack a DB cluster using the AWS CLI
  • Call the backtrack-db-cluster AWS CLI command and supply the following values:

    • --db-cluster-identifier – The name of the DB cluster.

    • --backtrack-to – The backtrack time stamp to backtrack the DB cluster to, specified in ISO 8601 format.

    The following example backtracks the DB cluster sample-cluster to March 19, 2018, at 10 a.m.

    For Linux, macOS, or Unix:

    aws rds backtrack-db-cluster \ --db-cluster-identifier sample-cluster \ --backtrack-to 2018-03-19T10:00:00+00:00

    For Windows:

    aws rds backtrack-db-cluster ^ --db-cluster-identifier sample-cluster ^ --backtrack-to 2018-03-19T10:00:00+00:00

To backtrack a DB cluster using the Amazon RDS API, use the BacktrackDBCluster operation. This operation backtracks the DB cluster specified in the DBClusterIdentifier value to the specified time.

To backtrack a DB cluster using the Amazon RDS API, use the BacktrackDBCluster operation. This operation backtracks the DB cluster specified in the DBClusterIdentifier value to the specified time.

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.