Home / Repstance User Guide / 6. DATABASE CONFIGURATION COMMANDS / 7.3 Validate Source and Target Databases / 7.3.4 Validate MySQL Database and Aurora MySQL Databases

7.3.4 Validate MySQL Database and Aurora MySQL Databases

REST API:

  • Endpoint: https://repstance_url/configure/database
  • Method: POST
  • Header:
    • Content-Type: application/json
    • X-Token: token
  • Body:
    {
      "command":"validate",
      "parameters":[
         ["database","target"],
         ["dbtype","mysql"],
         ["server","host_name"],
         ["port","port_number"],
         ["dbname","database_name"],
         ["user","db_user_name"],
         ["password","db_user_password"]
      ]
    }

Server response:

  • HTTP Status – status of the command, possible codes are:
    • 200 – if no error occurs
    • 422 – if error occurs
  • Body:
    {
     "Status":"{Valid|Invalid}",
     "Message":"The command execution details"
    }

CLI Syntax:

repcli validate database=target dbtype=mysql \
server=databaseHost port=databasePort \
user=username password=password \
dbname=databaseName

The input parameters are:

  • database – Database role, the only possible value is target – to validate Apply Process Objects
  • dbtype – Type of RDBMS, the value is mysql
  • server – Host name or IP address of the database server
  • port – Database port
  • dbname – Database name
  • user – Database User name
  • password – Database User password