Updated on 2023-02-02 GMT+08:00

Checking Whether the binlog_row_image Value is FULL

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.