Repair MySQL database tables

This function repairs all of the tables in a MySQL® database.

Important:

When you disable the MySQL/MariaDB role and remote MySQL is not already configured, the system disables this function.

SecurityBasicAuth
Request
query Parameters
name
required
string

The database's name.

Example: name=example_db
Responses
200

HTTP Request was successful.

Response Schema: application/json
apiversion
integer

The version of the API.

func
string

The name of the method called.

module
string

The name of the module called.

object
get/Mysql/repair_database
Request samples
uapi --output=jsonpretty \
  --user=username \
  Mysql \
  repair_database \
  name='example_db'
Response samples
application/json
{
  • "apiversion": 3,
  • "func": "repair_database",
  • "module": "Mysql",
  • "result": {
    • "data": [
      • {
        • "msg_text": "OK",
        • "msg_type": "status",
        • "table": "table1"
        }
      ],
    • "errors": null,
    • "messages": null,
    • "metadata": {
      • "transformed": 1
      },
    • "status": 1,
    • "warnings": null
    }
}