返回
首页
业界
电商
创业
访谈
手机
移动
报告
运营
建站
互联网+
系统
教程
搜索

MySQL从MyISAM转换成InnoDB错误与常用解决办法

2019-01-03 18:29:01王冬梅
InnoDB: Error: log file .ib_logfile0 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
101001  9:47:42 [ERROR] Default storage engine (InnoDB) is not available
101001  9:47:42 [ERROR] Aborting

101001  9:47:42 [Note] D:MySQL5binmysqld-nt: Shutdown complete

于是就到“MySQL5安装目录Data ”目录里把ib_logfile0日志文件删掉，重启MySQL服务，还是提示10067错误。再去查看err文件。
101001 18:39:29  InnoDB: Log file .ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .ib_logfile0 size to 109 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
InnoDB: Error: log file .ib_logfile1 is of different size 0 52428800 bytes
InnoDB: than specified in the .cnf file 0 114294784 bytes!
101001 18:39:30 [ERROR] Default storage engine (InnoDB) is not available
101001 18:39:30 [ERROR] Aborting

101001 18:39:30 [Note] D:MySQL5binmysqld-nt: Shutdown complete

可以看到，ib_logfile0的问题解决了，但是同样的问题却出在ib_logfile1上面了。于是依样画葫芦，把ib_logfile1删了，再重启MySQL服务，却发现没用。难道是还要重启系统。果真，把前面两个ib_logfile删了，重启系统就搞定了。前面的可能是因为刚开机，所以也行。实际上是需要重启系统的。这时的日志如下
101001 19:19:24  InnoDB: Log file .ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .ib_logfile0 size to 109 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
101001 19:19:26  InnoDB: Log file .ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .ib_logfile1 size to 109 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
InnoDB: Cannot initialize created log files because
相关文章 大家在看