backups

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

Overview

Name	backups
Type	Resource
Id	azure.mysql.backups

Fields

vw_backups

Name	Datatype	Description
backupName	text	field from the properties object
backup_type	text	field from the properties object
completed_time	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
source	text	field from the properties object
subscriptionId	text	field from the properties object

backups

Name	Datatype	Description
properties	object	The properties of a server backup.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	backupName, resourceGroupName, serverName, subscriptionId	List all the backups for a given server.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	List all the backups for a given server.
put	REPLACE	backupName, resourceGroupName, serverName, subscriptionId	Create backup for a given server with specified backup name.

SELECT examples

List all the backups for a given server.

vw_backups

SELECT
backupName,
backup_type,
completed_time,
resourceGroupName,
serverName,
source,
subscriptionId
FROM azure.mysql.vw_backups
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

backups

SELECT
properties
FROM azure.mysql.backups
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

REPLACE example

Replaces all fields in the specified backups resource.

/*+ update */
REPLACE azure.mysql.backups
SET 

WHERE 
backupName = '{{ backupName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';