霜天部落 | 关注LAMP高性能、高并发架构的设计与研究

解决MYSQL: Failed to open the relay log

在配置MySQL主从复制的过程中,遇到了一个问题,提示:Could not initialize master info structure; more error messages can be found in the MySQL error log。

打开log日志发现是因为如下的原因:

111121 15:15:22 [ERROR] Failed to open the relay log ‘./dong-relay-bin.000002’ (relay_log_pos 1067)

111121 15:15:22 [ERROR] Could not find target log during relay log initialization

可以按照下面的方法解决:

1、停止mysql服务

2、在mysql日志目录下删除所有的relay logs,包括hostname-relay-bin.XXX, hostname-relay-bin.index and relay-log.info等等

3、重启mysql服务

这样mysql就会重新生成relay 日志。

 



There are 1 Comments to "解决MYSQL: Failed to open the relay log"