首页 / PHP / MySQL启动报错Failed to open log (file 'D:\phpStudy\PHPTutorial\MySQL\data\mysql_bin.000045
MySQL启动报错Failed to open log (file 'D:\phpStudy\PHPTutorial\MySQL\data\mysql_bin.000045
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了MySQL启动报错Failed to open log (file 'D:\phpStudy\PHPTutorial\MySQL\data\mysql_bin.000045,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含1560字,纯文字阅读大概需要3分钟。
内容图文
MySQL报错
191105 9:39:07 [Note] Plugin 'FEDERATED' is disabled. 191105 9:39:07 InnoDB: The InnoDB memory heap is disabled 191105 9:39:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions 191105 9:39:07 InnoDB: Compressed tables use zlib 1.2.3 191105 9:39:07 InnoDB: Initializing buffer pool, size = 47.0M 191105 9:39:07 InnoDB: Completed initialization of buffer pool 191105 9:39:07 InnoDB: highest supported file format is Barracuda. 191105 9:39:08 InnoDB: Waiting for the background threads to start 191105 9:39:09 InnoDB: 5.5.53 started; log sequence number 2389058 D:\phpStudy\PHPTutorial\MySQL\bin\mysqld.exe: File 'D:\phpStudy\PHPTutorial\MySQL\data\mysql_bin.000045' not found (Errcode: 2) 191105 9:39:09 [ERROR] Failed to open log (file 'D:\phpStudy\PHPTutorial\MySQL\data\mysql_bin.000045', errno 2) 191105 9:39:09 [ERROR] Could not open log file 191105 9:39:09 [ERROR] Can't init tc log 191105 9:39:09 [ERROR] Aborting 191105 9:39:09 InnoDB: Starting shutdown... 191105 9:39:09 InnoDB: Shutdown completed; log sequence number 2389058 191105 9:39:09 [Note] D:\phpStudy\PHPTutorial\MySQL\bin\mysqld.exe: Shutdown complete
找到MySQL配置文件
D:\phpStudy\PHPTutorial\MySQL\my.ini
方法一:
在log_bin="D:/phpStudy/PHPTutorial/MySQL/data/mysql_bin"前面加#注释掉
方法二:
找到log_bin路径,里面有一个mysql.index,(我的路径是D:/phpStudy/PHPTutorial/MySQL/data)
打开mysql.index删除里面的D:\phpStudy\PHPTutorial\MySQL\data\mysql_bin.000045
(方法二需要注意,默认是mysql.index. 如果你和我一样改了默认log_bin配置,我改成mysql_bin了,所以我要改的文件是mysql_bin.index)
内容总结
以上是互联网集市为您收集整理的MySQL启动报错Failed to open log (file 'D:\phpStudy\PHPTutorial\MySQL\data\mysql_bin.000045全部内容,希望文章能够帮你解决MySQL启动报错Failed to open log (file 'D:\phpStudy\PHPTutorial\MySQL\data\mysql_bin.000045所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。