Copy database into another of a web hosting package
Copy all data of one database into another of the same package, in the background.
manitu_webhosting_web_database_copy on https://mcp.manitu.de/mcpAnnotations as tools/list sends them
Description for the model
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.
Arguments
site_idinteger | stringrequiredThe site_id from manitu_webhosting_list - never guess one.
database_idinteger | stringrequiredThe database_id from manitu_webhosting_web_database_list - never guess one.
target_database_idinteger | stringrequiredThe database_id from manitu_webhosting_web_database_list - never guess one.
charsetstringThe character set of the data: utf-8, or latin1 for an old database. Default: utf-8.
target_clear_firstbooleanEmpty the target first - all its tables go. Default: false.
dump_firstbooleanDump both databases into files in the web directory of the package before. Default: true.
Result structuredContent, checked against the schema
workflowstring | nullrequiredWhat is being done, e.g. power_reboot or ngcobalt_site_web_database_copy.
workflow_idstring | nullrequiredThe id of this run, as vserver/workflow/list names it; null for a workflow not kept as tasks.
statusstringrequiredpending: 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.
created_atstring | nullrequiredWhen it was asked for.
started_atstring | nullrequiredWhen it started; null while pending, and for a workflow that does not record it.
ended_atstring | nullrequiredWhen it finished; null until then.
updated_atstring | nullrequiredWhen it last changed.
workflow_tokenstring | nullrequiredPass 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.
Authentication
One of X-API-Key, Authorization: Bearer … - never more than one in a request. More
Request body JSON; unknown fields are refused
site_idinteger | stringrequiredThe site_id from manitu_webhosting_list - never guess one.
database_idinteger | stringrequiredThe database_id from manitu_webhosting_web_database_list - never guess one.
target_database_idinteger | stringrequiredThe database_id from manitu_webhosting_web_database_list - never guess one.
charsetstringThe character set of the data: utf-8, or latin1 for an old database. Default: utf-8.
target_clear_firstbooleanEmpty the target first - all its tables go. Default: false.
dump_firstbooleanDump both databases into files in the web directory of the package before. Default: true.
Response in data; the rest of the body as on every call
workflowstring | nullrequiredWhat is being done, e.g. power_reboot or ngcobalt_site_web_database_copy.
workflow_idstring | nullrequiredThe id of this run, as vserver/workflow/list names it; null for a workflow not kept as tasks.
statusstringrequiredpending: 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.
created_atstring | nullrequiredWhen it was asked for.
started_atstring | nullrequiredWhen it started; null while pending, and for a workflow that does not record it.
ended_atstring | nullrequiredWhen it finished; null until then.
updated_atstring | nullrequiredWhen it last changed.
workflow_tokenstring | nullrequiredPass 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.
Statuses
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.