Schema 'xyz' is not tracked via bin logs

Last updated on Oct 21, 2022
Error Message Text(s) - Schema: xyz is not tracked via bin logs

Potential Causes

  • Binary log replication is enabled but the schema in the request has been excluded from replication.

    Launch an SQL prompt and run the following query:

    SHOW MASTER STATUS;
    

    # Both of Binlog_Do_DB and Binlog_Ignore_DB should be empty OR
    # xyz must be present in Binlog_Do_DB column

Suggested Actions

  • Enable the schema xyz for replication by following the instructions here.

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Sep-05-2022 NA Created as a new page to keep all the MySQL troubleshooting guidance at one place.

Tell us what went wrong