This page describes how to cancel the import and export of data into Cloud SQL instances. This data is contained in either SQL dump files or CSV files.
Before you begin
Cancel the import or export operation
You can use gcloud
or REST API commands to cancel an import or
export operation.
gcloud sql operations cancel
command to cancel the operation.
gcloud sql operations canceloperation-ID
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, see Before 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)
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)
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
{}
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, see Before 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)
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)
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
{}
Check the cancelled status
You can use gcloud
or REST API commands to check the status of a
cancelled import or export operation.
gcloud sql operations describe
command to
check the status of the cancelled operation.
gcloud sql operations describeoperation-ID
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, see Before 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)
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)
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 " }
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, see Before 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)
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)
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
Issue | Troubleshooting |
---|---|
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 an operation type other than |
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, contact Google Cloud Support. |
What's next
- Learn more about best practices for importing and exporting data.
- Learn how to export and import data into Cloud SQL instances using SQL dump files.
- Learn how to check the status of import and export operations.
- Known issues for imports and exports.