本頁說明如何為 Cloud SQL 執行個體啟用、停用及管理保留的備份。
保留的備份是指執行個體刪除後保留的備份。 這些備份包括執行個體運作時建立的隨選和自動備份。如要進一步瞭解保留備份的運作方式,請參閱「保留備份」。
您隨時可以編輯執行個體,為執行個體啟用保留備份功能。您也可以將保留的備份資料還原至新的或現有執行個體。
事前準備
如要管理 Google Cloud 專案中保留的備份,您需要下列權限:
工作 | 所需權限 |
---|---|
列出備份 | cloudsql. |
描述備份 | cloudsql. |
更新備份 | cloudsql. |
刪除備份 | cloudsql.backupRuns.delete |
gcloud CLI
如要管理 Google Cloud 專案中保留的備份,您必須具備下列權限:
動作 | 指令 | 所需權限 |
---|---|---|
列出備份 | gcloud sql backups list |
cloudsql.backupRuns.list |
描述備份 | gcloud sql backups describe |
cloudsql.backupRuns.get |
更新備份 | gcloud sql backups patch |
cloudsql.backupRuns.update |
刪除備份 | gcloud sql backups delete |
cloudsql.backupRuns.delete |
REST
如要管理 Google Cloud 專案中保留的備份,您必須具備下列權限:
動作 | 方法 | 所需權限 |
---|---|---|
列出備份 | backups.listBackup |
cloudsql.backupRuns.list |
描述備份 | backups.getBackup |
cloudsql.backupRuns.get |
更新備份 | backups.updateBackup |
cloudsql.backupRuns.update |
刪除備份 | backups.deleteBackup |
cloudsql.backupRuns.delete |
為執行個體啟用保留備份
您可以在建立執行個體時,或編輯現有執行個體時,透過執行個體的「資料保護」設定選項啟用保留備份。
查看所有保留備份的清單
您可以使用Google Cloud 控制台、gcloud CLI 或 Cloud SQL API,查看專案中所有保留的備份清單。 Google Cloud 備份內容會包含備份名稱、所屬執行個體、備份類型,以及執行個體刪除時間等詳細資料。由於刪除的執行個體名稱可以重複使用,建議您使用 instance deletion time
欄位,區分特定備份檔所屬的執行個體。如果是即時執行個體,這個欄位會留空。
前往 Google Cloud 控制台的「Cloud SQL Backups」頁面。
按一下要查看備份的已刪除執行個體名稱。
畫面上會列出已刪除執行個體的所有保留和最終備份,以及相關詳細資料。
如要取得與 Google Cloud 專案相關聯的所有備份清單,請使用 gcloud sql backups list 指令:
gcloud sql backups list --project=
PROJECT_ID 更改下列內容:
PROJECT_ID
:您的 Google Cloud 專案 ID。
如要查看特定保留備份的詳細資料,請使用 gcloud sql backups describe 指令:
gcloud sql backups describe
BACKUP_NAME --project=PROJECT_ID 更改下列內容:
BACKUP_NAME
:保留備份的名稱。PROJECT_ID
:您的 Google Cloud 專案 ID。
取得所有保留備份的清單
使用這個範例,取得與Google Cloud 專案相關聯的所有保留備份清單。如需這項呼叫的完整參數清單,請參閱 backups.listBackups
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID
HTTP 方法和網址:
GET https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups"
PowerShell (Windows)
執行下列指令:
$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 /backups" | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "name": "projects/PROJECT_ID /backups/BACKUP_ID ", "kind": "sql#backup", "state": "SUCCESSFUL", "backupInterval": { "startTime": "2020-01-21T11:25:33.858Z", "endTime": "2020-01-21T11:26:18.663Z", } "type": "FINAL", "instance": "INSTANCE_ID ", "selfLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID ", "location": "us" "description": "This is a final backup.", "backupKind": "SNAPSHOT", "dataDiskSizeGB": "10", "expiryTime": "2020-01-30T11:26:18.663Z", "backup_run": "projects/PROJECT_ID /instances/INSTANCE_ID /backupRuns/BACKUP_RUN_ID ", "satisfies_pzs": false, "satisfies_pzi": false }
查看保留備份的詳細資料
使用這個範例查看保留備份的詳細資料。如需這項呼叫的完整參數清單,請參閱backup.getBackup
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID。
- BACKUP_ID:備份 ID。這個 ID 是從執行上一個呼叫的輸出內容取得。
HTTP 方法和網址:
GET https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID "
PowerShell (Windows)
執行下列指令:
$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 /backups/BACKUP_ID " | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "name": "projects/PROJECT_ID /backups/BACKUP_ID ", "kind": "sql#backup", "status": "SUCCESSFUL", "backupInterval": { "startTime": "2020-01-21T11:25:33.858Z", "endTime": "2020-01-21T11:26:18.663Z", } "type": "FINAL", "instance": "INSTANCE_ID ", "selfLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID ", "location": "us" "description": "final backup", "backupKind": "SNAPSHOT", "dataDiskSizeGB": "10", "expiryTime": "2020-01-30T11:26:18.663Z", "backup_run": "projects/PROJECT_ID /instances/INSTANCE_ID /backupRuns/BACKUP_RUN_ID ", "satisfies_pzs": false, "satisfies_pzi": false }
取得所有保留備份的清單
使用這個範例,取得與Google Cloud 專案相關聯的所有保留備份清單。如需這項呼叫的完整參數清單,請參閱 backups.listBackups
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID
HTTP 方法和網址:
GET https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups"
PowerShell (Windows)
執行下列指令:
$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }
Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups" | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "name": "projects/PROJECT_ID /backups/BACKUP_ID ", "kind": "sql#backup", "state": "SUCCESSFUL", "backupInterval": { "startTime": "2020-01-21T11:25:33.858Z", "endTime": "2020-01-21T11:26:18.663Z", } "type": "FINAL", "instance": "INSTANCE_ID ", "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID ", "location": "us" "description": "This is a final backup.", "backupKind": "SNAPSHOT", "dataDiskSizeGB": "10", "expiryTime": "2020-01-30T11:26:18.663Z", "backup_run": "projects/PROJECT_ID /instances/INSTANCE_ID /backupRuns/BACKUP_RUN_ID ", "satisfies_pzs": false, "satisfies_pzi": false }
查看保留備份的詳細資料
使用這個範例查看保留備份的詳細資料。如需這項呼叫的完整參數清單,請參閱backups.getBackup
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID。
- BACKUP_ID:備份 ID。這個 ID 是從執行上一個呼叫的輸出內容取得。
HTTP 方法和網址:
GET https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID "
PowerShell (Windows)
執行下列指令:
$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }
Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID " | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "name": "projects/PROJECT_ID /backups/BACKUP_ID ", "kind": "sql#backup", "status": "SUCCESSFUL", "backupInterval": { "startTime": "2020-01-21T11:25:33.858Z", "endTime": "2020-01-21T11:26:18.663Z", } "type": "FINAL", "instance": "INSTANCE_ID ", "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID ", "location": "us" "description": "final backup", "backupKind": "SNAPSHOT", "dataDiskSizeGB": "10", "expiryTime": "2020-01-30T11:26:18.663Z", "backup_run": "projects/PROJECT_ID /instances/INSTANCE_ID /backupRuns/BACKUP_RUN_ID ", "satisfies_pzs": false, "satisfies_pzi": false }
更新保留備份的說明
您隨時可以更新保留備份資料的說明,方便識別備份資料。
前往 Google Cloud 控制台的「Cloud SQL Backups」頁面。
按一下要查看備份的已刪除執行個體名稱。
畫面上會列出已刪除執行個體的所有保留和最終備份,以及相關詳細資料。
找出要更新的備份,然後依序點按「更多動作」圖示
和「編輯說明」。
在「編輯備份說明」視窗中,更新備份說明。
按一下「更新」。
如要更新保留備份的說明,請使用 gcloud sql backups patch 指令:
gcloud sql backups patch BACKUP_NAME
--description=BACKUP_DESCRIPTION
更改下列內容:
BACKUP_NAME
:保留備份的名稱。BACKUP_DESCRIPTION
:您要新增至保留備份的新說明。
取得所有保留備份的清單
使用這個範例,取得與Google Cloud 專案相關聯的所有保留備份清單。如需這項呼叫的完整參數清單,請參閱 backups.listBackups
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID
HTTP 方法和網址:
GET https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups"
PowerShell (Windows)
執行下列指令:
$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 /backups" | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "name": "projects/PROJECT_ID /backups/BACKUP_ID ", "kind": "sql#backup", "state": "SUCCESSFUL", "backupInterval": { "startTime": "2020-01-21T11:25:33.858Z", "endTime": "2020-01-21T11:26:18.663Z", } "type": "FINAL", "instance": "INSTANCE_ID ", "selfLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID ", "location": "us" "description": "This is a final backup.", "backupKind": "SNAPSHOT", "dataDiskSizeGB": "10", "expiryTime": "2020-01-30T11:26:18.663Z", "backup_run": "projects/PROJECT_ID /instances/INSTANCE_ID /backupRuns/BACKUP_RUN_ID ", "satisfies_pzs": false, "satisfies_pzi": false }
更新說明
請使用這個範例更新保留備份的說明。如需這項呼叫的完整參數清單,請參閱backups.updateBackup
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID。
- BACKUP_ID:備份 ID。這個 ID 是從執行上一個呼叫的輸出內容取得。
- DESCRIPTION:最終備份的更新說明。
HTTP 方法和網址:
PATCH https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID ?update_mask=description
JSON 要求主體:
{ "backup": { "description":DESCRIPTION , }, }
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
將要求主體儲存在名為 request.json
的檔案中,然後執行下列指令:
curl -X PATCH \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json; charset=utf-8" \
-d @request.json \
"https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID ?update_mask=description"
PowerShell (Windows)
將要求主體儲存在名為 request.json
的檔案中,然後執行下列指令:
$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }
Invoke-WebRequest `
-Method PATCH `
-Headers $headers `
-ContentType: "application/json; charset=utf-8" `
-InFile request.json `
-Uri "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID ?update_mask=description" | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "kind": "sql#operation", "targetLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID ", "status": "DONE", "user": "user@example.com", "insertTime": "2024-02-15T00:10:22.078Z", "operationType": "UPDATE_BACKUP", "name": "OPERATION_ID ", "targetId": "BACKUP_ID ", "selfLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /operations/OPERATION_ID ", "targetProject": "PROJECT_ID " }
取得所有保留備份的清單
使用這個範例,取得與Google Cloud 專案相關聯的所有保留備份清單。如需這項呼叫的完整參數清單,請參閱 backups.listBackups
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID
HTTP 方法和網址:
GET https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups"
PowerShell (Windows)
執行下列指令:
$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }
Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups" | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "name": "projects/PROJECT_ID /backups/BACKUP_ID ", "kind": "sql#backup", "state": "SUCCESSFUL", "backupInterval": { "startTime": "2020-01-21T11:25:33.858Z", "endTime": "2020-01-21T11:26:18.663Z", } "type": "FINAL", "instance": "INSTANCE_ID ", "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID ", "location": "us" "description": "This is a final backup.", "backupKind": "SNAPSHOT", "dataDiskSizeGB": "10", "expiryTime": "2020-01-30T11:26:18.663Z", "backup_run": "projects/PROJECT_ID /instances/INSTANCE_ID /backupRuns/BACKUP_RUN_ID ", "satisfies_pzs": false, "satisfies_pzi": false }
更新說明
請使用這個範例更新保留備份的說明。如需這項呼叫的完整參數清單,請參閱backups.updateBackup
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID。
- BACKUP_ID:備份 ID。這個 ID 是從執行上一個呼叫的輸出內容取得。
- DESCRIPTION:最終備份的更新說明。
HTTP 方法和網址:
PATCH https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID ?update_mask=description
JSON 要求主體:
{ "backup": { "description":DESCRIPTION , }, }
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
將要求主體儲存在名為 request.json
的檔案中,然後執行下列指令:
curl -X PATCH \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json; charset=utf-8" \
-d @request.json \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID ?update_mask=description"
PowerShell (Windows)
將要求主體儲存在名為 request.json
的檔案中,然後執行下列指令:
$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }
Invoke-WebRequest `
-Method PATCH `
-Headers $headers `
-ContentType: "application/json; charset=utf-8" `
-InFile request.json `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID ?update_mask=description" | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "kind": "sql#operation", "targetLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID ", "status": "DONE", "user": "user@example.com", "insertTime": "2024-02-15T00:10:22.078Z", "operationType": "UPDATE_BACKUP", "name": "OPERATION_ID ", "targetId": "BACKUP_ID ", "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /operations/OPERATION_ID ", "targetProject": "PROJECT_ID " }
刪除保留的備份
您可以使用 Google Cloud 控制台、gcloud CLI 或 Cloud SQL API 刪除保留的備份。
前往 Google Cloud 控制台的「Cloud SQL Backups」頁面。
按一下要查看備份的已刪除執行個體名稱。
畫面上會列出已刪除執行個體的所有保留和最終備份,以及相關詳細資料。
找到要刪除的保留備份,按一下更多動作圖示
,然後選取「刪除」。
在「Delete backup」(刪除備份) 視窗中,輸入已刪除的執行個體名稱,然後按一下「Delete」(刪除)。
如要刪除保留的備份,請使用 gcloud sql backups delete
指令:
gcloud sql backups delete BACKUP_NAME
更改下列內容:
BACKUP_NAME
:保留備份的名稱。
取得所有保留備份的清單
使用這個範例,取得與Google Cloud 專案相關聯的所有保留備份清單。如需這項呼叫的完整參數清單,請參閱 backups.listBackups
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID
HTTP 方法和網址:
GET https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups"
PowerShell (Windows)
執行下列指令:
$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 /backups" | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "name": "projects/PROJECT_ID /backups/BACKUP_ID ", "kind": "sql#backup", "state": "SUCCESSFUL", "backupInterval": { "startTime": "2020-01-21T11:25:33.858Z", "endTime": "2020-01-21T11:26:18.663Z", } "type": "FINAL", "instance": "INSTANCE_ID ", "selfLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID ", "location": "us" "description": "This is a final backup.", "backupKind": "SNAPSHOT", "dataDiskSizeGB": "10", "expiryTime": "2020-01-30T11:26:18.663Z", "backup_run": "projects/PROJECT_ID /instances/INSTANCE_ID /backupRuns/BACKUP_RUN_ID ", "satisfies_pzs": false, "satisfies_pzi": false }
刪除保留的備份
使用這個範例刪除保留的備份。如需這項呼叫的完整參數清單,請參閱backups.deleteBackup
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID。
- BACKUP_ID:備份 ID。這個 ID 是從執行上一個呼叫的輸出內容取得。
HTTP 方法和網址:
DELETE https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X DELETE \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID "
PowerShell (Windows)
執行下列指令:
$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }
Invoke-WebRequest `
-Method DELETE `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID " | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "kind": "sql#operation", "targetLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /backups/BACKUP_ID ", "status": "PENDING", "user": "user@example.com", "insertTime": "2020-01-21T22:43:37.981Z", "operationType": "DELETE_BACKUP", "name": "OPERATION_ID ", "targetId": "BACKUP_ID ", "selfLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID /operations/OPERATION_ID ", "targetProject": "PROJECT_ID " }
取得所有保留備份的清單
使用這個範例,取得與Google Cloud 專案相關聯的所有保留備份清單。如需這項呼叫的完整參數清單,請參閱 backups.listBackups
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID
HTTP 方法和網址:
GET https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups"
PowerShell (Windows)
執行下列指令:
$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }
Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups" | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "name": "projects/PROJECT_ID /backups/BACKUP_ID ", "kind": "sql#backup", "state": "SUCCESSFUL", "backupInterval": { "startTime": "2020-01-21T11:25:33.858Z", "endTime": "2020-01-21T11:26:18.663Z", } "type": "FINAL", "instance": "INSTANCE_ID ", "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID ", "location": "us" "description": "This is a final backup.", "backupKind": "SNAPSHOT", "dataDiskSizeGB": "10", "expiryTime": "2020-01-30T11:26:18.663Z", "backup_run": "projects/PROJECT_ID /instances/INSTANCE_ID /backupRuns/BACKUP_RUN_ID ", "satisfies_pzs": false, "satisfies_pzi": false }
刪除保留的備份
使用這個範例刪除保留的備份。如需這項呼叫的完整參數清單,請參閱backups.deleteBackup
頁面。
使用任何要求資料之前,請先替換以下項目:
- PROJECT_ID:專案 ID。
- BACKUP_ID:備份 ID。這個 ID 是從執行上一個呼叫的輸出內容取得。
HTTP 方法和網址:
DELETE https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID
如要傳送要求,請展開以下其中一個選項:
curl (Linux、macOS 或 Cloud Shell)
執行下列指令:
curl -X DELETE \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID "
PowerShell (Windows)
執行下列指令:
$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }
Invoke-WebRequest `
-Method DELETE `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID " | Select-Object -Expand Content
您應該會收到如下的 JSON 回應:
回應
{ "kind": "sql#operation", "targetLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /backups/BACKUP_ID ", "status": "PENDING", "user": "user@example.com", "insertTime": "2020-01-21T22:43:37.981Z", "operationType": "DELETE_BACKUP", "name": "OPERATION_ID ", "targetId": "BACKUP_ID ", "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID /operations/OPERATION_ID ", "targetProject": "PROJECT_ID " }