mysql Could not initialize master info structure; more error messages can be found in the MySQL erro
来源:互联网 发布:json字符串转对象 编辑:程序博客网 时间:2024/05/16 06:11
在MySQL主从复制的时候,在slave服务器上,登陆MySQL,
使用 stop slave;
这时候系统提示:
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
但当执行start slave;的时候,就出现了如下错误:
mysql> start slave;
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
mysql>
解决办法:
1.进入MySQL数据库默认的数据库存储目录:
/usr/local/mysql/var
这个目录根据实际情况而定,使用不同的安装方式,或是编译指定目录不同,这个目录也不一定相同,但只要找到数据库的存储目录就好。
2.删除以下两个文件:
master.info
relay-log.info
3.登陆数据库后,执行:
start slave;
返回如下信息:
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql>
这样就说明问题已经解决了。
0 0
- mysql Could not initialize master info structure; more error messages can be found in the MySQL erro
- Could not initialize master info structure; more error messages can be found in the MySQL error log
- ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in
- ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in
- mysql Could not initialize master info structure;
- mysql Could not initialize master info structure 解决方法
- MySQL Slave环境出现ERROR 1201 (HY000): Could not initialize master info structure的案例
- MySQL主从复制:ERROR 1201 (HY000): Could not initialize master info structure.
- ERROR 1201 (HY000): Could not initialize master info structure
- 解决ERROR 1201 (HY000): Could not initialize master info structure
- ERROR 1201 (HY000): Could not initialize master info structure解决方法
- ERROR 1201 (HY000):Could not initialize master info structure,ERROR 29 (HY000): File'./web_appdb_的问题
- ERROR 1201 (HY000):Could not initialize master info structure的问题(转载)
- 故障案例:级联主从change master to Could not initialize master info structure
- mysql:The package 'mysql' can be found in following packages
- Eclipse:Some sites could not be found. See the error log for more detail.解决办法
- Eclipes提示Some sites could not be found. See the error log for more detail
- mysql安装error:the security setting could not be applied
- 17个你必须牢记的Win7快捷键
- Spring MVC 中 HandlerInterceptorAdapter过滤器的使用
- [应用模板]单列布局网站
- VLAN原理详解
- 在程序中输出日志, 使用 android.util.Log 类.
- mysql Could not initialize master info structure; more error messages can be found in the MySQL erro
- How to custom search results in SharePoint Server 2013
- 基于visual Studio2013解决算法导论之005原地随机排列数组
- 关于const,static,extern,volatile的用法
- 简明 Vim 练级攻略
- 五个不为人知的ESC键妙用
- nodejs npm install -g 全局安装和非全局安装的区别
- MySQL 获取 数据库 和 表信息 方法小结
- 黑马程序员_IO流(4)