The solution to the problem of Mysql master and slave library _mysql

Encountered such errors as: "Last_io_error:got fatal error 1236 from master when reading the data from binary log: ' Could ' is not find ' e name in binary log index file ' ", etc. or due to the clearing of data caused the master and slave library is not synchronized, the solution is as follows:

First enter the slave to execute: "Slave stop;" To stop synchronizing from the library;

Then go to Master to execute: "Flush logs;" To clear the log;

Then execute in master: "Show master status;" View the status of the main library, mainly log files and position;

Then go back to Slave and execute: "Change master to master_log_file= ' log-bin.000004 ', master_log_pos=106;", File and location corresponding to master;

Finally in the slave: "Slave start;" To initiate synchronization.