Esta página aún no está disponible en su idioma local. Estamos trabajando arduamente para agregar más versiones de idiomas. Gracias por tu apoyo.

On this page

Show all

Checking Whether the binlog_row_image Value is FULL

Updated on 2022-09-21 GMT+08:00

MySQL

Table 1 Checking whether the binlog_row_image value is FULL

Check Item

Whether the binlog_row_image value is FULL

Description

If the binlog_row_image value of the source database is not FULL, the migration will fail.

Failure Cause and Handling Suggestion

Failure cause: The binlog_row_image value of the source database is not FULL.

Handling suggestion:

  • If the source database is an RDS DB instance on the cloud, change binlog_row_image to FULL on the RDS console, and then restart the source database.
  • If the source database is an on-premises database, perform the following steps:
    1. Log in to the server where the MySQL source database is located.
    2. Manually change the value of binlog_row_image in the my.cnf configuration file to FULL and save the file.
      binlog_row_image=full
    3. To ensure a successful task, restart the source database during off-peak hours.
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback