Why is the Schema Mapper section for my BinLog Pipeline empty?

Wait for some time until a few transactions are done on the database.

Hevo shows information of the tables that have registered some activity in the binary logs since the creation of the Pipeline. In the absence of any activity, neither the data nor the schema will show up.

Use the mysqlbinlog utility to read samples from the binary logs. (The mysqlbinlog is available in the mysql server package. So, you may have to install it on the client machine from which you will perform the tests.)

# Run this on an SQL prompt to get the name of the binary log files:

SHOW BINARY LOGS;

# Run the following on a shell to check if there is any activity in binary log:


mysqlbinlog -R -h<Host> -u<User> -p -P<Port> <latest_bin_log> | grep insert|delete|update|alter

# If there is nothing there, you probably need to wait.

If the query logging is enabled for your database server, you may refer to the logs to check if queries have been logged in the recent times.


Revision History

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

Date Release Description of Change
Nov-07-2022 NA Created as a new document.
Last updated on 03 Nov 2022

Tell us what went wrong