Copy database into another of a web hosting package

Copy all data of one database into another of the same package, in the background.

DDestructiveNot idempotentbetaNeeds service_webhosting
Tool
manitu_webhosting_web_database_copyon https://mcp.manitu.de/mcp
POST
/v1/webhosting/web/database/copyon https://api.manitu.de
Try it
Removes something for good. Agents name what will be lost and wait for an explicit yes; a program should ask the same.
readOnlyHint falsedestructiveHint trueidempotentHint falseopenWorldHint false

Copies all data of a database (database_id) into another database (target_database_id) of the same web hosting package of the manitu customer account this connection works in, both from manitu_webhosting_web_database_list - e.g. a live shop into a test copy. It runs in the background: ask manitu_workflow_get with the workflow_token until status is done or error. Tables of the target with the same name are replaced; target_clear_first true empties the target first. dump_first (default true) writes both databases into files in the web directory of the package before. Both must be on the same kind of server, and manitu must know both passwords (password_not_stored otherwise). Refused with a conflict when the package cannot be changed now (not_configurable). Ask the customer for an explicit yes first, naming which database is overwritten.

site_idinteger | stringrequired

The site_id from manitu_webhosting_list - never guess one.

pattern ^[1-9][0-9]*$min 1
database_idinteger | stringrequired

The database_id from manitu_webhosting_web_database_list - never guess one.

pattern ^[1-9][0-9]*$min 1
target_database_idinteger | stringrequired

The database_id from manitu_webhosting_web_database_list - never guess one.

pattern ^[1-9][0-9]*$min 1
charsetstring

The character set of the data: utf-8, or latin1 for an old database. Default: utf-8.

One of utf-8 latin1
target_clear_firstboolean

Empty the target first - all its tables go. Default: false.

dump_firstboolean

Dump both databases into files in the web directory of the package before. Default: true.

workflowstring | nullrequired

What is being done, e.g. power_reboot or ngcobalt_site_web_database_copy.

One of create destroy power_start power_stop power_reboot reinstall ptr_set vnc_enable vnc_disable rescuesystem_enable rescuesystem_disable snapshot_create snapshot_delete snapshot_delete_all snapshot_revert telemetry_await iso_eject none account_contract_termination_finish ngcobalt_site_web_application_installation_set ngcobalt_site_web_application_installation_update ngcobalt_site_web_permission_set ngcobalt_site_web_database_copy network_librenms_discover null
workflow_idstring | nullrequired

The id of this run, as vserver/workflow/list names it; null for a workflow not kept as tasks.

statusstringrequired

pending: waiting to start; running: started, not finished (can take a while); done: finished, everything went through; error: finished, but it or part of it failed.

One of pending running done error
created_atstring | nullrequired

When it was asked for.

Format date-time
started_atstring | nullrequired

When it started; null while pending, and for a workflow that does not record it.

Format date-time
ended_atstring | nullrequired

When it finished; null until then.

Format date-time
updated_atstring | nullrequired

When it last changed.

Format date-time
workflow_tokenstring | nullrequired

Pass it to manitu_workflow_get to see how far the workflow is - as it is, never built or changed. A secret of this workflow: do not show it to anyone. null if there is none.

One of X-API-Key, Authorization: Bearer … - never more than one in a request. More

site_idinteger | stringrequired

The site_id from manitu_webhosting_list - never guess one.

pattern ^[1-9][0-9]*$min 1
database_idinteger | stringrequired

The database_id from manitu_webhosting_web_database_list - never guess one.

pattern ^[1-9][0-9]*$min 1
target_database_idinteger | stringrequired

The database_id from manitu_webhosting_web_database_list - never guess one.

pattern ^[1-9][0-9]*$min 1
charsetstring

The character set of the data: utf-8, or latin1 for an old database. Default: utf-8.

One of utf-8 latin1
target_clear_firstboolean

Empty the target first - all its tables go. Default: false.

dump_firstboolean

Dump both databases into files in the web directory of the package before. Default: true.

workflowstring | nullrequired

What is being done, e.g. power_reboot or ngcobalt_site_web_database_copy.

One of create destroy power_start power_stop power_reboot reinstall ptr_set vnc_enable vnc_disable rescuesystem_enable rescuesystem_disable snapshot_create snapshot_delete snapshot_delete_all snapshot_revert telemetry_await iso_eject none account_contract_termination_finish ngcobalt_site_web_application_installation_set ngcobalt_site_web_application_installation_update ngcobalt_site_web_permission_set ngcobalt_site_web_database_copy network_librenms_discover null
workflow_idstring | nullrequired

The id of this run, as vserver/workflow/list names it; null for a workflow not kept as tasks.

statusstringrequired

pending: waiting to start; running: started, not finished (can take a while); done: finished, everything went through; error: finished, but it or part of it failed.

One of pending running done error
created_atstring | nullrequired

When it was asked for.

Format date-time
started_atstring | nullrequired

When it started; null while pending, and for a workflow that does not record it.

Format date-time
ended_atstring | nullrequired

When it finished; null until then.

Format date-time
updated_atstring | nullrequired

When it last changed.

Format date-time
workflow_tokenstring | nullrequired

Pass it to manitu_workflow_get to see how far the workflow is - as it is, never built or changed. A secret of this workflow: do not show it to anyone. null if there is none.

200Success.400The request does not match the declared input schema.401No credential was presented, or it was not recognised.403The credential is not permitted to use this operation.500The server failed. Nothing about the request was wrong. Whether a change took effect is not known - check before trying it again.503The channel this operation forwards through is unavailable.