The Operations resource represents an operation that was performed on a Cloud SQL instance, for example, by using one of the Instances or SslCerts resource methods.
For a list of methods for this resource, see the end of this page.
Resource representations
An Operations resource contains information about database instance operations such as create, delete, and restart. Operations resources are created in response to operations that were initiated; you never create them directly.
{
"kind": "sql#instanceOperation",
"instance": string,
"operation": string,
"operationType": string,
"state": string,
"userEmailAddress": string,
"enqueuedTime": datetime,
"startTime": datetime,
"endTime": datetime,
"error": [
{
"kind": "sql#operationError",
"code": string
}
],
"importContext": {
"kind": "sql#importContext",
"uri": [
string
],
"database": string
},
"exportContext": {
"kind": "sql#exportContext",
"uri": string,
"database": [
string
],
"table": [
string
]
}
}
| Property name | Value | Description | Notes |
|---|---|---|---|
endTime
|
datetime
|
The time this operation finished in UTC timezone in
RFC 3339
format, for example
2012-11-15T16:19:00.094Z
.
|
|
enqueuedTime
|
datetime
|
The time this operation was enqueued in UTC timezone in
RFC 3339
format, for example
2012-11-15T16:19:00.094Z
.
|
|
error[]
|
list
|
The error(s) encountered by this operation. Only set if the operation results in an error. | |
error[].
code
|
string
|
Identifies the specific error that occurred. | |
error[].
kind
|
string
|
This is always
sql#operationError
.
|
|
exportContext
|
nested object
|
The context for export operation, if applicable. | |
exportContext.
database[]
|
list
|
Databases (for example,
guestbook
) from which the export is made. If unspecified, all databases are exported.
|
|
exportContext.
kind
|
string
|
This is always
sql#exportContext
.
|
|
exportContext.
table[]
|
list
|
Tables to export, or that were exported, from the specified database. If you specify tables, specify one and only one database. | |
exportContext.
uri
|
string
|
The path to the file in Google Cloud Storage where the export will be stored, or where it was already stored. The URI is in the form
gs://bucketName/fileName
. If the file already exists, the operation fails. If the filename ends with .gz, the contents are compressed.
|
|
importContext
|
nested object
|
The context for import operation, if applicable. | |
importContext.
database
|
string
|
The database (for example,
guestbook
) to which the import is made. If not set, it is assumed that the database is specified in the file to be imported.
|
|
importContext.
kind
|
string
|
This is always
sql#importContext
.
|
|
importContext.
uri[]
|
list
|
A path to the MySQL dump file in Google Cloud Storage from which the import is made. The URI is in the form
gs://bucketName/fileName
. Compressed gzip files (.gz) are also supported.
|
|
instance
|
string
|
Name of the database instance. | |
kind
|
string
|
This is always
sql#instanceOperation
.
|
|
operation
|
string
|
An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation. | |
operationType
|
string
|
The type of the operation. Valid values are
CREATE
,
DELETE
,
UPDATE
,
RESTART
,
IMPORT
,
EXPORT
,
BACKUP_VOLUME
,
RESTORE_VOLUME
.
|
|
startTime
|
datetime
|
The time this operation actually started in UTC timezone in
RFC 3339
format, for example
2012-11-15T16:19:00.094Z
.
|
|
state
|
string
|
The state of an operation. Valid values are
PENDING
,
RUNNING
,
DONE
,
UNKNOWN
.
|
|
userEmailAddress
|
string
|
The email address of the user who initiated this operation. |
Methods
Available methods for Operations resources are: