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.

  • Before calling this API, obtain the required region and endpoint.

Constraints

  • Read replicas do not support manual backup creation.

  • The backup name must be unique.

URI

  • URI format

    POST https://{Endpoint}/v3/{project_id}/backups

  • Parameter description

    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    For details about how to obtain the project ID, see Obtaining a Project ID.

Request

  • Parameter description

    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 Microsoft SQL Server databases that are partially backed up. (Only Microsoft SQL Server support partial backups.)

    For details, see Table 3.

    Table 3 databases field data structure description

    Name

    Mandatory

    Type

    Description

    name

    Yes

    String

    Specifies the names of self-built databases.

  • Request example

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

    Creating a manual backup for a MySQL or PostgreSQL DB instance:

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

    Creating a manual backup for a Microsoft SQL Server DB instance:

    {
        "instance_id": "d8e6ca5a624745bcb546a227aa3ae1cfin04",
        "name": "backup",
        "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 Microsoft SQL Server databases that are partially backed up. (Only Microsoft SQL Server support 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 a MySQL or PostgreSQL DB instance:

    {
        "backup": {
            "id": "2f4ddb93-b901-4b08-93d8-1d2e472f30fe",
            "name": "backupDemo",
            "description": "This is a description",
            "begin_time": "2016-09-12T01:17:05",
            "status": "BUILDING",
            "type": "manual",
            "instance_id": "d8e6ca5a624745bcb546a227aa3ae1cfin01"
        }
    }
    

    Creating a manual backup for a Microsoft SQL Server DB instance:

    {
        "backup": {
            "id": "2f4ddb93-b901-4b08-93d8-1d2e472f30fe",
            "name": "backupDemo",
            "description": "This is a description",
            "begin_time": "2016-09-12T01:17:05",
            "status": "BUILDING",
            "type": "manual",
            "instance_id": "d8e6ca5a624745bcb546a227aa3ae1cfin01",
            "databases": [{
                "name": "db1"
            }]
        }
    }
    
  • Abnormal response

    For details, see Abnormal Request Results.

Status Code

Error Code

For details, see Error Codes.