MySQL报错：Slave: Failed to initial
2018-12-26 本文已影响0人
飞翔的Tallgeese
恢复到线下，启动时error.log有报错
Error looking for /home/mysql/data3034/mysql/slave-relay.002519.
Slave: Failed to initialize the master info structure for channel ''; its record may still be present in 'mysql.slave_master_info' table, consider deleting it.
Failed to create or recover replication info repositories.
登陆mysql，执行reset slave，然后重启解决该问题
（线上是双机，而线下只是一个单实例，所以只需要reset slave就够了；如果线下也是双机，需要执行change master...那一堆）
