Skip to main content

backup_and_exports

Creates, updates, deletes, gets or lists a backup_and_exports resource.

Overview

Namebackup_and_exports
TypeResource
Idazure.mysql.backup_and_exports

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
createinsertsubscriptionId, resourceGroupName, serverName, data__backupSettings, data__targetDetailsExports the backup of the given server by creating a backup if not existing.
validate_backupexecsubscriptionId, resourceGroupName, serverNameValidates if backup can be performed for given server.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
serverNamestringThe name of the server.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

INSERT examples

Exports the backup of the given server by creating a backup if not existing.

INSERT INTO azure.mysql.backup_and_exports (
data__backupSettings,
data__targetDetails,
subscriptionId,
resourceGroupName,
serverName
)
SELECT
'{{ backupSettings }}' /* required */,
'{{ targetDetails }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ serverName }}'
RETURNING
endTime,
error,
percentComplete,
properties,
startTime,
status
;

Lifecycle Methods

Validates if backup can be performed for given server.

EXEC azure.mysql.backup_and_exports.validate_backup 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@serverName='{{ serverName }}' --required
;