Restore an instance

This page describes how to restore your instance from a backup and perform a point-in-time recovery of an instance.

For information, best practices, and requirements for restore operations or point-in-time recovery, see Overview of restoring an instance.

Restore an instance from a backup

You can use a backup to restore the same instance the backup was taken from, or you can use a backup to restore a different instance in the same project.

Restore to a different instance

When you restore from a backup to a different instance, you update the data on the target instance to the state of the source instance when you took the backup. For more information, see General tips about performing a restore and Tips and requirements for restoring to a different instance.

If you need a list of backups for the project and can't view them on the instance overview page due to an outage, you can use the backupRuns.list API with a wildcard (-). The wildcard option retrieves a list of all backups across all instances in the project. For more information, see Viewing backups during an outage.

Console

  1. In the Google Cloud console, go to the Cloud SQL Instances page.

    Go to Cloud SQL Instances

  2. If the target instance has any read replicas, use the more actions menu More actions icon. on the far right side to delete them.
  3. To open the Overview page of an instance, click the instance name.
  4. Select Backups from the SQL navigation menu.
  5. Find the backup you want to restore from, and select Restore.
  6. In the Restore an instance from a backup page, confirm that you selected the correct backup in Review backup details.
  7. In Choose restore destination, select Overwrite an existing instance.
  8. From the Instance drop-down menu, select the instance you want to use for the restore. The instance that you select and all of its data are overwritten.
  9. To confirm your selection, enter the name of the instance to be overwritten in the Destination instance ID field.
  10. To start the restore process, click Restore.
  11. Check the status of the restore operation by going to the Operations tab of the target instance.
  12. After the restore operation completes, recreate any replicas you deleted previously.

gcloud

  1. Describe the target instance to see whether it has any replicas:
    gcloud sql instances describe TARGET_INSTANCE_NAME
    

    Note any instances listed in replicaNames.

  2. Delete all replicas:
    gcloud sql instances delete REPLICA_NAME
    

    Repeat for each replica.

  3. List the backups for the source instance:
    gcloud sql backups list \
    --instance SOURCE_INSTANCE_NAME
    
  4. Find the backup you want to use and record its ID value.
  5. Restore from the specified backup to the target instance:
    gcloud sql backups restore BACKUP_ID \
    --restore-instance=TARGET_INSTANCE_NAME \
    --backup-instance=SOURCE_INSTANCE_NAME
        
  6. After the restore completes, recreate any replicas you deleted previously.

REST v1

  1. List all replicas for the target instance.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID

    HTTP method and URL:

    GET https://sqladmin.googleapis.com/v1/projects/project-id/instances/instance-id?fields=replicaNames

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  2. Delete all replicas.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • replica-id: The replica ID

    HTTP method and URL:

    DELETE https://sqladmin.googleapis.com/v1/projects/project-id/instances/replica-id

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

    Repeat for each replica.

  3. List the backups for the source instance to get the ID of the backup you want to use.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID

    HTTP method and URL:

    GET https://sqladmin.googleapis.com/v1/projects/project-id/instances/instance-id/backupRuns

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

    -OR- If your instance is in a region that is having an outage, list all the backups in a project:

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID, or - for a list of all backups in the project

    HTTP method and URL:

    GET https://sqladmin.googleapis.com/v1/projects/project-id/instances/-/backupRuns

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

    Find the backup for the instance you need to restore.
  4. Restore the target instance from the backup.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • target-instance-id: The target instance ID
    • source-instance-id: The source instance ID
    • backup-id The backup ID

    HTTP method and URL:

    POST https://sqladmin.googleapis.com/v1/projects/project-id/instances/target-instance-id/restoreBackup

    Request JSON body:

    {
      "restoreBackupContext":
      {
        "backupRunId": backup-id,
        "instanceId": "source-instance-id"
      }
    }
    

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  5. After the restore operation completes, recreate any replicas you deleted previously.

REST v1beta4

  1. List all replicas for the target instance.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID

    HTTP method and URL:

    GET https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id?fields=replicaNames

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  2. Delete all replicas.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • replica-id: The replica ID

    HTTP method and URL:

    DELETE https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/replica-id

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

    Repeat for each replica.

  3. List the backups for the source instance to get the ID of the backup you want to use.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID

    HTTP method and URL:

    GET https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id/backupRuns

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  4. Restore the target instance from the backup.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • target-instance-id: The target instance ID
    • source-instance-id: The source instance ID
    • backup-id The backup ID

    HTTP method and URL:

    POST https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/target-instance-id/restoreBackup

    Request JSON body:

    {
      "restoreBackupContext":
      {
        "backupRunId": backup-id,
        "instanceId": "source-instance-id"
      }
    }
    

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  5. After the restore operation completes, recreate any replicas you deleted previously.

Restore to the same instance

When you restore from a backup to the same instance, you return the data on that instance to the state of when you took the backup. For information about restoring an instance, see General tips about performing a restore.

Console

  1. In the Google Cloud console, go to the Cloud SQL Instances page.

    Go to Cloud SQL Instances

  2. If the target instance has any read replicas, use the more actions menu More actions icon. at the far right side to delete them.
  3. To open the Overview page of an instance, click the instance name.
  4. Select Backups from the SQL navigation menu.
  5. Find the backup you want to use, and select Restore.
  6. In the Restore an instance from a backup page, confirm that you selected the correct backup in Review backup details.
  7. In Choose restore destination, select Overwrite the source instance.

    Check that the name of the source instance is specified in parentheses.

  8. To confirm your selection, enter the instance name in the Destination instance ID field.
  9. To start the restore process, click Restore.
  10. Check the status of the restore operation by going to the Operations page of the instance.
  11. After the restore operation completes, recreate any replicas you deleted in the first step.

gcloud

  1. Describe the instance to see whether it has any replicas:
    gcloud sql instances describe INSTANCE_NAME
    

    Note any instances listed in replicaNames.

  2. Delete all replicas:
    gcloud sql instances delete REPLICA_NAME
    

    Repeat for all replicas.

  3. List the backups for the instance:
    gcloud sql backups list --instance INSTANCE_NAME
    
  4. Find the backup you want to use and record its ID value.
  5. Restore the instance from the specified backup:
    gcloud sql backups restore BACKUP_ID \
    --restore-instance=INSTANCE_NAME
    
  6. After the restore operation completes, recreate any replicas you deleted in the first step.

REST v1

  1. List all replicas for the instance.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID

    HTTP method and URL:

    GET https://sqladmin.googleapis.com/v1/projects/project-id/instances/instance-id?fields=replicaNames

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  2. Delete all replicas.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • replica-id: The replica ID

    HTTP method and URL:

    DELETE https://sqladmin.googleapis.com/v1/projects/project-id/instances/replica-id

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

    Repeat for each read replica.

  3. List the backups for the instance to get the id of the backup you want to use.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID

    HTTP method and URL:

    GET https://sqladmin.googleapis.com/v1/projects/project-id/instances/instance-id/backupRuns

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  4. Restore the instance from the backup.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID
    • backup-id The backup ID

    HTTP method and URL:

    POST https://sqladmin.googleapis.com/v1/projects/project-id/instances/instance-id/restoreBackup

    Request JSON body:

    {
      "restoreBackupContext":
      {
        "backupRunId": "backup-id",
      }
    }
    

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  5. After the restore operation completes, recreate any replicas you deleted previously.

REST v1beta4

  1. List all replicas for the instance.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID

    HTTP method and URL:

    GET https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id?fields=replicaNames

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  2. Delete all replicas.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • replica-id: The replica ID

    HTTP method and URL:

    DELETE https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/replica-id

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

    Repeat for each read replica.

  3. List the backups for the instance to get the id of the backup you want to use.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID

    HTTP method and URL:

    GET https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id/backupRuns

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  4. Restore the instance from the backup.

    Before using any of the request data, make the following replacements:

    • project-id: The project ID
    • instance-id: The instance ID
    • backup-id The backup ID

    HTTP method and URL:

    POST https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id/restoreBackup

    Request JSON body:

    {
      "restoreBackupContext":
      {
        "backupRunId": "backup-id",
      }
    }
    

    To send your request, expand one of these options:

    You should receive a JSON response similar to the following:

  5. After the restore operation completes, recreate any replicas you deleted previously.

Restore to an instance in another project

You can use the project parameter to restore data to an instance in a different project than the one where the backup was taken. When using the project parameter, call restoreBackup in the project and on the instance you want to restore data to. When you restore from a backup to a different instance, you update the data on the target instance to the state of the source instance when you took the backup.

Permissions

The user restoring to a different project must have the cloudsql.instances.restoreBackup permission for the target project and the cloudsql.backupRuns.get permission for the source instance. These permissions are included in the Cloud SQL Admin role.

To restore data to an instance in a different project:

REST v1

To obtain the backupId, run the following.

Before using any of the request data, make the following replacements:

  • project-id: The project ID
  • instance-id: The instance ID

HTTP method and URL:

GET https://sqladmin.googleapis.com/v1/projects/project-id/instances/instance-id/backupRuns

To send your request, expand one of these options:

You should receive a JSON response similar to the following:

Restore the backup to an instance in a different project:

Before using any of the request data, make the following replacements:

  • source-project-id: The source project ID
  • target-project-id: The target project ID
  • target-instance-id: The target instance ID
  • source-instance-id: The source instance ID
  • backup-id The backup ID

HTTP method and URL:

POST https://sqladmin.googleapis.com/v1/projects/target-project-id/instances/target-instance-id/restoreBackup

Request JSON body:

{
  "restoreBackupContext":
  {
    "backupRunId": backup-id,
    "project": "source-project-id",
    "instanceId": "source-instance-id"
  }
}

To send your request, expand one of these options:

You should receive a JSON response similar to the following:

For more information about the project property, see restoreBackup

REST v1beta4

To obtain the backupId, run the following.

Before using any of the request data, make the following replacements:

  • project-id: The project ID
  • instance-id: The instance ID

HTTP method and URL:

GET https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id/backupRuns

To send your request, expand one of these options:

You should receive a JSON response similar to the following:

Restore the backup to an instance in a different project:

Before using any of the request data, make the following replacements:

  • source-project-id: The source project ID
  • target-project-id: The target project ID
  • target-instance-id: The target instance ID
  • source-instance-id: The source instance ID
  • backup-id The backup ID

HTTP method and URL:

POST https://sqladmin.googleapis.com/sql/v1beta4/projects/target-project-id/instances/target-instance-id/restoreBackup

Request JSON body:

{
  "restoreBackupContext":
  {
    "backupRunId": backup-id,
    "project": "source-project-id",
    "instanceId": "source-instance-id"
  }
}

To send your request, expand one of these options:

You should receive a JSON response similar to the following:

For more information about the project property, see restoreBackup

Perform a point-in-time recovery

To perform a point-in-time recovery, see Point-in-time recovery.

Identify the recovery position

Before you can perform a point-in-time recovery, you must have identified a binary log file name and position that correspond to the point in time you want to recover the instance to.

To accomplish this task, see Identifying the recovery position.

What's next