美文网首页MySQL(总)
MySQL报错:Slave: Failed to initial

MySQL报错:Slave: Failed to initial

作者: 飞翔的Tallgeese | 来源:发表于2018-12-26 21:56 被阅读0次

    恢复到线下,启动时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...那一堆)

    相关文章

      网友评论

        本文标题:MySQL报错:Slave: Failed to initial

        本文链接:https://www.haomeiwen.com/subject/evgklqtx.html