Creating a Manual Backup

Function

This API is used to create a manual backup.

Before calling an API, you need to understand the API in Authentication.

Constraints

Microsoft SQL Server supports batch calling of this API to create manual backups for one database.

Read replicas do not support manual backup creation.
The backup name must be unique.

URI

URI format
POST /v3/{project_id}/backups

Parameter description

**Table 1** Parameter description
Name	Mandatory	Description
project_id	Yes	Project ID of a tenant in a region. For details about how to obtain the project ID, see Obtaining a Project ID.

Request

**Table 2** Parameter description
Name	Mandatory	Type	Description
instance_id	Yes	String	Specifies the DB instance ID.
name	Yes	String	Specifies the backup name. It must be 4 to 64 characters long, start with a letter, and contain only letters (case-sensitive), digits, hyphens (-), and underscores (_). The backup name must be unique.
description	No	String	Specifies the backup description. It contains a maximum of 256 characters and cannot contain the following special characters: >!<"&'=
databases	No	Array of objects	Specifies a list of self-built RDS for SQL Server databases that are partially backed up. (Only RDS for SQL Server supports partial backups.) For details, see Table 3.
backup_database_individually	No	Boolean	Specifies whether to back up databases individually. This parameter is available to RDS for SQL Server only. The default value is false.

**Table 3** databases field data structure description
Name	Mandatory	Type	Description
name	Yes	String	Specifies the names of self-built databases.

Example Request

Create a manual backup mybackup for an RDS for MySQL DB instance.

POST https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/backups

{
	"instance_id": "d8e6ca5a624745bcb546a227aa3ae1cfin01",
	"name": "mybackup",
	"description": "manual backup"
}

Create a manual backup mybackup for an RDS for PostgreSQL DB instance.

{
	"instance_id": "a8a5fc65b1a04ceb9d72212891ad73f8in03",
	"name": "mybackup",
	"description": "manual backup"
}

Create a manual backup mybackup for an RDS for SQL Server DB instance.

{
	"instance_id": "34029da944074135a3bc24c75b3bb3edin04",
	"name": "mybackup",
	"description": "manual backup",
	"databases": [{
		"name": "db1"
	}, {
		"name": "db2"
	}]
}

Response

Normal response

**Table 4** Parameter description
Name	Type	Description
backup	Object	Indicates the backup information. For details, see Table 5.

**Table 5** backup field data structure description
Name	Type	Description
id	String	Indicates the backup ID.
instance_id	String	Indicates the DB instance ID.
name	String	Indicates the backup name.
description	String	Indicates the backup description.
databases	Array of objects	Indicates a list of self-built RDS for SQL Server databases that are partially backed up. (Only RDS for SQL Server supports partial backups.) For details, see Table 3.
begin_time	String	Indicates the backup start time in the "yyyy-mm-ddThh:mm:ssZ" format, where "T" indicates the start time of the time field, and "Z" indicates the time zone offset.
status	String	Indicates the backup status. Value: BUILDING: Backup in progress COMPLETED: Backup completed FAILED: Backup failed DELETING: Backup being deleted
type	String	Indicates the backup type. Value: auto: automated full backup manual: manual full backup fragment: differential full backup incremental: automated incremental backup

Example normal response

Creating a manual backup for an RDS for MySQL DB instance:

{
	"backup": {
		"id": "cb211c0075104151a748a854bc8bd87dbr01",
		"name": "mybackup",
		"description": "manual backup",
		"begin_time": "2022-08-23T07:41:50Z",
		"status": "BUILDING",
		"type": "manual",
		"instance_id": "d8e6ca5a624745bcb546a227aa3ae1cfin01"
	}
}

Creating a manual backup for an RDS for PostgreSQL DB instance:

{
	"backup": {
		"id": "104b59afd83d4fc7b2c03ad14c4be080br03",
		"name": "mybackup",
		"description": "manual backup",
		"begin_time": "2022-08-23T07:20:36Z",
		"status": "BUILDING",
		"type": "manual",
		"instance_id": "a8a5fc65b1a04ceb9d72212891ad73f8in03"
	}
}

Creating a manual backup for an RDS for SQL Server DB instance:

{
	"backup": {
		"id": "6f7b5904b04043b38ad764e33daba810br04",
		"name": "mybackup",
		"description": "manual backup",
		"begin_time": "2022-08-23T07:15:28Z",
		"status": "BUILDING",
		"type": "manual",
		"instance_id": "34029da944074135a3bc24c75b3bb3edin04",
		"databases": [{
			"name": "db1"
                }, {
			"name": "db2"
		}]
	}
}