《Mysql應用Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not》要點:
本文介紹了Mysql應用Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not,希望對您有用。如果有疑問,可以聯系我們。
導讀:在slave啟動報錯:Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not...
在slave啟動報錯:
MYSQL實例“Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’”
MYSQL實例解決:報錯的原因主要是slave設置master的二進制文件名或pos值不對應!
MYSQL實例先flush logs;清空日志,在查看下主數據庫的狀態?show master status;看下日志文件名字和position值;
MYSQL實例再在slave中,執行:CHANGE MASTER TO MASTER_LOG_FILE=‘二進制日志名’,MASTER_LOG_POS=值;
MYSQL實例最后啟動同步進程:start?slave;
轉載請注明本頁網址:
http://www.snjht.com/jiaocheng/5554.html