MySQL Master error screenshot

1, first confirm the error Binlog and last event.

2, then go to the main machine to see the error content and the location of the error, if the end of the error, you can directly from the new Binlog synchronization.

#/mysql/logs#. /bin/mysqlbinlog--start-position=506063695 mysql-bin.000159 | Less

3, see the error is the last value of the file (Binlog abnormal shutdown caused), you can directly define the synchronization from the starting point, synchronization.

mysql> Change Master to master_log_file= ' mysql-bin.000160 ', master_log_pos=4

Note: The new sync start point requires viewing the error on the main library after the Binlog new Binlog and the new Binlog start POS

#/home/work/mysql/logs#. /bin/mysqlbinlog mysql-bin.000159 | More

MySQL Master error