MySQL database master/slave copy/share error

Data from the shared master is not obtained, error message: Waiting for master to send event

Solution:

1. Get Prno data from V-table

SELECT * from Vendor_pricemaster where prno= ' PR16100012 ';

2. Displays the status of connecting from slave to master Master

SHOW SLAVE STATUS;

3. Skip a command that cannot be executed;

3.1 Close from the library;

STOP SLAVE;

3.2 Set global sql_slave_skip_counter=n, that is, the N event is skipped from the current position at start slave. Each event is skipped, then n--.

STOP SLAVE; SET GLOBAL sql_slave_skip_counter = 2000;

3.3 Open from library;

START SLAVE;

4. Paste updates from the main Library copy table to the from library;

MySQL database master/slave copy/share error