Recently, encountered the MySQL master and slave library synchronization problem, mainly because the computer broke a bit of electricity, toss AH.
Error from library log: Last_io_error:got fatal error 1236 from master, reading data from binary log: ' could ' Name in binary log index file '
Solution:
1. First stop synchronization from the library;
Slave stop;
2. Empty the log in the main library:
Flush logs;
3. View the main library status, mainly view the log file and location:
Show master status;
4. Back from the library, execute the command to make the log file and location corresponding to the main library:
Change MASTER to master_log_file= ' log-bin.000005 ', master_log_pos=107;
5. Finally, start from the library:
Slave start;
A successful solution!
Last_io_error:got fatal Error 1236 from master when reading data from binary log: ' could ' Binary Log index file ' "