Fleetdock
API referenceBackupsDatabasesIdImport sql

Import a SQL file

Applies a SQL dump (max 2 GB) to the database through the restore path, running as the database's read-write role — never as the instance admin. The staged file is deleted afterwards. Requires database:write and backup:write.

POST
/v1/databases/{id}/import-sql

Applies a SQL dump (max 2 GB) to the database through the restore path, running as the database's read-write role — never as the instance admin. The staged file is deleted afterwards. Requires database:write and backup:write.

Authorization

bearerAuth
AuthorizationBearer <token>

In: header

Path Parameters

id*string
Formatuuid

Query Parameters

destination_id*string

Backup destination used to stage the file for the executor.

Formatuuid
gzip?boolean

The body is already gzip-compressed.

Request Body

application/octet-stream

TypeScript Definitions

Use the request body type in TypeScript.

body*file
Formatbinary

Response Body

curl -X POST "https://example.com/v1/databases/497f6eca-6276-4993-bfeb-53cbbbba6f08/import-sql?destination_id=497f6eca-6276-4993-bfeb-53cbbbba6f08" \  -H "Content-Type: application/octet-stream" \  -d 'string'
Empty

Check a downloaded backup can start POST

Verifies that a one-off dump of the database can start: the dump tool is installed on the control plane and the database accepts the instance's admin login. Call it before `GET /v1/databases/{id}/dump` to report problems as an error instead of a failed download. Requires backup:write on the database.

List backup destinations GET

Next Page