MySQL 5.5在Windows Server 2008 R2上出现1067错误

Question

MySQL 5.5在Windows Server 2008 R2上出现1067错误

mysqlinnodbwindows-server-2008-r2logfilemysql-error-1067

3

我在两个月前在Windows Server 2008 R2上安装了MySQL Server 5.5，一直都在正常运行。但是突然间，MySQL服务停止了工作，我也无法重新启动该服务。错误信息:

121120 14:33:31 [Note] Plugin 'FEDERATED' is disabled.
121120 14:33:31 InnoDB: The InnoDB memory heap is disabled
121120 14:33:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121120 14:33:31 InnoDB: Compressed tables use zlib 1.2.3
121120 14:33:31 InnoDB: Initializing buffer pool, size = 2.0G
121120 14:33:31 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 95420416 bytes
InnoDB: than specified in the .cnf file 0 224395264 bytes!
121120 14:33:31 [ERROR] Plugin 'InnoDB' init function returned error.
121120 14:33:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121120 14:33:31 [ERROR] Unknown/unsupported storage engine: INNODB
121120 14:33:31 [ERROR] Aborting

121120 14:33:31 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

我该如何解决这个问题？

- Saharsh Shah

1个回答

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- Mathlight · Accepted Answer

这是错误信息：

InnoDB: Error: log file .\ib_logfile0 is of different size 0 95420416 bytes
InnoDB: than specified in the .cnf file 0 224395264 bytes!

你可以搜索那个.cnf文件并将字节从 224395264 更改为 95420416。也许那会有所帮助...

更新：如此处所述：更改InnoDB日志文件大小当服务器没有运行时，你可以删除日志文件 ( .\ib_logfile0 ) ，然后问题就不会再出现了...