Incremental Backup Examples

Incremental backup examples for MariaDB Cloud via the SkySQL Backup API; incremental backups require an existing full backup and capture only changes since the last backup.

Go to the MariaDB Cloud API Key management page and generate an API key. Export the value from the token field to an environment variable $API_KEYexport API_KEY='... key data ...'

Use it on subsequent request, e.g: bash curl --request

GET 'https://api.skysql.com/skybackup/v1/backups/schedules' \
    --header "X-API-Key: ${API_KEY}"

Incremental Backup

Incremental backups can be taken once you have full backup. Read here for more details.

One-Time Incremental

To set up an one-time incremental backup, you need to make the following API call:

curl --location 'https://api.skysql.com/skybackup/v1/backups/schedules' \
--header 'Content-Type: application/json' \
--header 'Accept: application/json' \
--header 'X-API-Key: ${API_KEY}' \
--data '{
    "backup_type": "incremental",
    "schedule": "once",
    "service_id": "$SERVICE_ID"
}'

• API_KEY : SKYSQL API KEY, see MariaDB Cloud API Keys

• SERVICE_ID : MariaDB Cloud service identifier, format dbtxxxxxx. You can fetch the service ID from the Fully qualified domain name(FQDN) of your service. E.g: in dbpgf17106534.sysp0000.db2.skysql.com, 'dbpgf17106534' is the service ID.You will find the FQDN in the Connect window

Cron Incremental

To set up an cron incremental backup, you need to make the following API call:

curl --location 'https://api.skysql.com/skybackup/v1/backups/schedules' \
--header 'Content-Type: application/json' \
--header 'Accept: application/json' \
--header 'X-API-Key: ${API_KEY}' \
--data '{
    "backup_type": "incremental",
    "schedule": "0 3 * * *",
    "service_id": "$SERVICE_ID"
}'

• API_KEY : SKYSQL API KEY, see MariaDB Cloud API Keys

• SCHEDULE : Cron schedule, see Cron

• SERVICE_ID : MariaDB Cloud service identifier, format dbtxxxxxx

Backup status can be fetched using https://api.skysql.com/skybackup/v1/backups. See the 'Backup Status' section for an example.

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}