由于使用时间比较长积累了很多的日志文件(\data目录下),所以删除之! mysql-bin.000001
... ...
mysql-bin.000278
原来删除都留最后一个编号的日志,这次太过彻底~~都删了!
执行net start mysql:
出现了mysql 1067错误!
查看,主机名.err文件(lenovo-7c8f808d.err):
[plain] view plaincopyprint?
130416 9:59:23 innodb: started; log sequence number 0 43655 mysql: file '.\mysql-bin.000278' not found (errcode: 2) 130416 9:59:23 [error] failed to open log (file '.\mysql-bin.000278', errno 2) 130416 9:59:23 [error] could not open log file 130416 9:59:23 [error] can't init tc log 130416 9:59:23 [error] aborting 130416 9:59:23 innodb: starting shutdown... 130416 9:59:24 innodb: shutdown completed; log sequence number 0 43655 130416 9:59:24 [note] mysql: shutdown complete 130416 9:59:23 innodb: started; log sequence number 0 43655mysql: file '.\mysql-bin.000278' not found (errcode: 2)130416 9:59:23 [error] failed to open log (file '.\mysql-bin.000278', errno 2)130416 9:59:23 [error] could not open log file130416 9:59:23 [error] can't init tc log130416 9:59:23 [error] aborting130416 9:59:23 innodb: starting shutdown...130416 9:59:24 innodb: shutdown completed; log sequence number 0 43655130416 9:59:24 [note] mysql: shutdown complete
告诉我们找不到mysql-bin.000278文件!
既然找不到,我们新弄一个日志文件:
打开my.ini文件
更改红框中的文字为:mysql-b
保存my.ini文件。
重新启动mysql服务:
正常启动mysql了!
