MYSQL: Failed to open the relay log解决办法
- WBOYOriginal
- 2016-06-07 17:52:402280browse
昨天在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 日志。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql5.5提示Could not initialize master info structureNext article：msyql中子查询IN，EXISTS，ANY，ALL，UNION介绍