今天在使用mysql是提示ould not initialize master info structure錯誤,下面我來給各位朋友總結一下解決辦法.

MySQL 設定同步 Replication,將下述命令拆成兩組輸入,如下述:

1.mysql> CHANGE MASTER TO MASTER_HOST='master.example.com', MASTER_USER='repl', MASTER_PASSWORD='repl_password';

2.mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=107;

設定 Replication 完成后,start slave 無法啟動,出現下述錯誤訊息:

Could not initialize master info structure, more error messages can be found in the MySQL error log

要怎么解決呢?

MySQL Replication 出現 Could not initialize master info structure 修復

MySQL error log 看不出有什么錯誤訊息, 可看此篇的討論: MySQL :: Could not initialize master info structure, more error messages can be found in the MySQL error log //Vevb.com

下述直接寫解法:

1.mysql> reset slave; # 重點就是這行

2.mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=107; # 請依照自行環境設定

3.mysql> start slave; # 就正常了.

4.?: 重新設置 slave,MASTER_LOG_FILE 和 MASTER_LOG_POS 會被清空,所以需要重新設置.