Cancel the import and export of data

MySQL  |  PostgreSQL  |  SQL Server

This page describes how to cancel the import and export of data into Cloud SQLinstances. This data is contained in eitherSQL dump files orBAK files.

Before you begin

To cancel the import and export of data, you need the ID of the importor export operation. You need to specify this ID in thegcloud or REST API command so that Cloud SQL knows which operation to cancel.

The operation ID is returned in thename field of the response. To obtain this ID, seeExport and import using SQL dump files.

You can also find the operation ID by making anoperations.list call on the Cloud SQL instance.

Cancel the import or export operation

You can usegcloud or REST API commands to cancel an import orexport operation.

gcloud

Use thegcloud sql operations cancel command to cancel the operation.

gcloudsqloperationscanceloperation-ID

Replace theoperation-ID variable with the ID of the operation. For more information, seeBefore you begin.

REST v1

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

  • project-ID: The project ID.
  • operation-ID: The ID of the import or export operation. For more information, seeBefore you begin.

HTTP method and URL:

POST https://sqladmin.googleapis.com/v1/projects/project-ID/operations/operation-ID/cancel

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Note: The following command assumes that you have logged in to thegcloud CLI with your user account by runninggcloud init orgcloud auth login , or by usingCloud Shell, which automatically logs you into thegcloud CLI . You can check the currently active account by runninggcloud auth list.

Execute the following command:

curl -X POST \
     -H "Authorization: Bearer $(gcloud auth print-access-token)" \
     -H "Content-Type: application/json; charset=utf-8" \
     -d "" \
     "https://sqladmin.googleapis.com/v1/projects/project-ID/operations/operation-ID/cancel"

PowerShell (Windows)

Note: The following command assumes that you have logged in to thegcloud CLI with your user account by runninggcloud init orgcloud auth login . You can check the currently active account by runninggcloud auth list.

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
    -Method POST `
    -Headers $headers `
    -Uri "https://sqladmin.googleapis.com/v1/projects/project-ID/operations/operation-ID/cancel" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{}
This REST API call doesn't return any response. For more information about checking the cancellation status of the import or export operation, seeCheck the cancelled status.

REST v1beta4

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

  • project-ID: The project ID.
  • operation-ID: The ID of the import or export operation. For more information, seeBefore you begin.

HTTP method and URL:

POST https://sqladmin.googleapis.com/v1beta4/projects/project-ID/operations/operation-ID/cancel

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Note: The following command assumes that you have logged in to thegcloud CLI with your user account by runninggcloud init orgcloud auth login , or by usingCloud Shell, which automatically logs you into thegcloud CLI . You can check the currently active account by runninggcloud auth list.

Execute the following command:

curl -X POST \
     -H "Authorization: Bearer $(gcloud auth print-access-token)" \
     -H "Content-Type: application/json; charset=utf-8" \
     -d "" \
     "https://sqladmin.googleapis.com/v1beta4/projects/project-ID/operations/operation-ID/cancel"

PowerShell (Windows)

Note: The following command assumes that you have logged in to thegcloud CLI with your user account by runninggcloud init orgcloud auth login . You can check the currently active account by runninggcloud auth list.

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
    -Method POST `
    -Headers $headers `
    -Uri "https://sqladmin.googleapis.com/v1beta4/projects/project-ID/operations/operation-ID/cancel" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{}
This REST API call doesn't return any response. For more information about checking the cancellation status of the import or export operation, seeCheck the cancelled status.

Check the cancelled status

You can usegcloud or REST API commands to check the status of acancelled import or export operation.

gcloud

Use thegcloud sql operations describe command to check the status of the cancelled operation.

gcloudsqloperationsdescribeoperation-ID

Replace theoperation-ID variable with the ID of the cancelled operation. For more information, seeBefore you begin.

REST v1

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

  • project-ID: The project ID.
  • operation-ID: The ID of the import or export operation. For more information, seeBefore you begin.

HTTP method and URL:

GET https://sqladmin.googleapis.com/v1/projects/project-ID/operations/operation-ID

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Note: The following command assumes that you have logged in to thegcloud CLI with your user account by runninggcloud init orgcloud auth login , or by usingCloud Shell, which automatically logs you into thegcloud CLI . You can check the currently active account by runninggcloud auth list.

Execute the following command:

curl -X GET \
     -H "Authorization: Bearer $(gcloud auth print-access-token)" \
     "https://sqladmin.googleapis.com/v1/projects/project-ID/operations/operation-ID"

PowerShell (Windows)

Note: The following command assumes that you have logged in to thegcloud CLI with your user account by runninggcloud init orgcloud auth login . You can check the currently active account by runninggcloud auth list.

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
    -Method GET `
    -Headers $headers `
    -Uri "https://sqladmin.googleapis.com/v1/projects/project-ID/operations/operation-ID" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{  "kind": "sql#operation","targetLink": "https://sqladmin.googleapis.com/v1/projects/project-ID",  "status": "DONE",  "user": "user@example.com",  "insertTime": "2022-11-08T22:12:58.199Z",  "startTime": "2022-11-08T22:13:04.798Z",  "endTime": "2022-11-08T22:13:45.862Z",  "error": {    "kind": "sql#operationErrors",    "errors": [      {        "kind": "sql#operationError",        "code": "CANCEL_SUCCESSFUL",        "message": "Operation successfully cancelled"      }    ]  },  "operationType": "EXPORT",  "exportContext": {    "uri": "gs://replica-bucket/source-database.sql",    "kind": "sql#exportContext",    "sqlExportOptions": {      "schemaOnly": false,      "mysqlExportOptions": {        "masterData": 0      }    },    "fileType": "SQL"  },  "name": "operation-ID",  "targetId": "cloud-sql-instance-display-name",  "selfLink": "https://sqladmin.googleapis.com/v1/projects/project-ID/operations/operation-ID",  "targetProject": "project-ID",  "instanceUid": "cloud-sql-instance-ID"}

REST v1beta4

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

  • project-ID: The project ID.
  • operation-ID: The ID of the import or export operation. For more information, seeBefore you begin.

HTTP method and URL:

GET https://sqladmin.googleapis.com/v1beta4/projects/project-ID/operations/operation-ID

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Note: The following command assumes that you have logged in to thegcloud CLI with your user account by runninggcloud init orgcloud auth login , or by usingCloud Shell, which automatically logs you into thegcloud CLI . You can check the currently active account by runninggcloud auth list.

Execute the following command:

curl -X GET \
     -H "Authorization: Bearer $(gcloud auth print-access-token)" \
     "https://sqladmin.googleapis.com/v1beta4/projects/project-ID/operations/operation-ID"

PowerShell (Windows)

Note: The following command assumes that you have logged in to thegcloud CLI with your user account by runninggcloud init orgcloud auth login . You can check the currently active account by runninggcloud auth list.

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
    -Method GET `
    -Headers $headers `
    -Uri "https://sqladmin.googleapis.com/v1beta4/projects/project-ID/operations/operation-ID" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{  "kind": "sql#operation","targetLink": "https://sqladmin.googleapis.com/v1beta4/projects/project-ID",  "status": "DONE",  "user": "user@example.com",  "insertTime": "2022-11-08T22:12:58.199Z",  "startTime": "2022-11-08T22:13:04.798Z",  "endTime": "2022-11-08T22:13:45.862Z",  "error": {    "kind": "sql#operationErrors",    "errors": [      {        "kind": "sql#operationError",        "code": "CANCEL_SUCCESSFUL",        "message": "Operation successfully cancelled"      }    ]  },  "operationType": "EXPORT",  "exportContext": {    "uri": "gs://replica-bucket/source-database.sql",    "kind": "sql#exportContext",    "sqlExportOptions": {      "schemaOnly": false,      "mysqlExportOptions": {        "masterData": 0      }    },    "fileType": "SQL"  },  "name": "operation-ID",  "targetId": "cloud-sql-instance-display-name",  "selfLink": "https://sqladmin.googleapis.com/v1beta4/projects/project-ID/operations/operation-ID",  "targetProject": "project-ID",  "instanceUid": "cloud-sql-instance-ID"}

Troubleshoot

IssueTroubleshooting
Error message:You can't cancel operation [operation-ID] because this operation isn't in progress.

You're trying to cancel an import or export operation that's completed, failed, or cancelled. If the operation is running, you can cancel it.

Error message:You can't cancel operation [operation-ID] because Cloud SQL doesn't support the cancellation of an [operation-type] operation.

Cloud SQL doesn't support the cancellation of the operation because it has anoperation type other thanIMPORT orEXPORT.

Error message:The [operation-type] operation isn't cancelled. Wait and retry in a few seconds.

Cloud SQL can't cancel the import or export operation at this time. Try again in a few seconds. If the problem persists, contactGoogle Cloud Support.

What's next

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-07-18 UTC.