Restores
Get all Restores operations
page number
items per page
ServiceID Query
physical or logical
asc or desc
OK
Bad Request
Internal Server Error
GET /skybackup/v1/restores?service_id=text HTTP/1.1
Host: api.skysql.com/
X-API-Key: YOUR_API_KEY
Accept: */*
{
"pages_count": 1,
"restores": [
{
"backup_id": "text",
"bucket": "text",
"created_at": "text",
"id": 1,
"message": "text",
"service_id": "text",
"service_name": "text",
"status": "text",
"type": "text"
}
],
"restores_count": 1
}Create new Restore operation
key represents unique backup id
timestamp represents date and time value in 'CCYY-MM-DD hh:mm:ss' format
service id represents unique database id
OK
Bad Request
Internal Server Error
POST /skybackup/v1/restores HTTP/1.1
Host: api.skysql.com/
X-API-Key: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 155
{
"external_source": {
"bucket": "text",
"credentials": [
1
],
"encryption_key": "text",
"method": "mysqldump"
},
"id": "text",
"point_in_time": "text",
"service_id": "text"
}{
"backup_id": "text",
"bucket": "text",
"created_at": "text",
"id": 1,
"message": "text",
"service_id": "text",
"service_name": "text",
"status": "text",
"type": "text"
}Look up eligible Services for Restore by Backup ID
BackupID unique backup id
ServiceID represents unique database id of the source service
OK
Bad Request
Internal Server Error
POST /skybackup/v1/restores/lookup HTTP/1.1
Host: api.skysql.com/
X-API-Key: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 40
{
"backup_id": "text",
"service_id": "text"
}{
"services": [
{
"service_id": "text",
"service_name": "text"
}
]
}Look up eligible Services to provide backups for Point in time Restore
OK
Bad Request
Internal Server Error
GET /skybackup/v1/restores/pointintime/lookup HTTP/1.1
Host: api.skysql.com/
X-API-Key: YOUR_API_KEY
Accept: */*
{
"services": [
{
"end_time": "text",
"service_id": "text",
"service_name": "text",
"start_time": "text"
}
]
}Get single Restore operation
Restore ID
OK
Bad Request
Not Found
Internal Server Error
GET /skybackup/v1/restores/{id} HTTP/1.1
Host: api.skysql.com/
X-API-Key: YOUR_API_KEY
Accept: */*
{
"backup_id": "text",
"bucket": "text",
"created_at": "text",
"id": 1,
"message": "text",
"service_id": "text",
"service_name": "text",
"status": "text",
"type": "text"
}Delete single Restore operation
Restore ID
OK
No content
Bad Request
Not Found
Internal Server Error
DELETE /skybackup/v1/restores/{id} HTTP/1.1
Host: api.skysql.com/
X-API-Key: YOUR_API_KEY
Accept: */*
No content
Was this helpful?