Checking Whether the Source Database Binlog Is Enabled

Whether the source database binlog is enabled

Check whether binlog is enabled for the source database.

Failure cause: This item cannot be checked because the source database fails to be connected.

Handling suggestion: Check whether the source database is connected.

Failure cause: Insufficient user permissions

Handling suggestion: Check whether the database user permissions meet the migration requirements.

Failure cause: An internal error occurs.

Handling suggestion: Contact technical support.

Failure cause: The binlog function is disabled on the source database.

Handling suggestion:

• If the source is an on-premises database, perform the following operations to enable binlog.
  1. Run the following command to check whether binlog is enabled:

     show variables like "log_bin"\G;

     

  2. If binlog is disabled, add log-bin = mysql-bin followed by [mysqld] in the MySQL configuration file my.cnf or my.ini.

     

  3. Restart the database.