启动mysql失败,提示错误1067,进程意外终止。
11090410:45:35[Note]Plugin'FEDERATED'isdisabled.11090410:45:35InnoDB:TheInnoDBmemoryh...
110904 10:45:35 [Note] Plugin 'FEDERATED' is disabled.
110904 10:45:35 InnoDB: The InnoDB memory heap is disabled
110904 10:45:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110904 10:45:35 InnoDB: Compressed tables use zlib 1.2.3
110904 10:45:35 InnoDB: Initializing buffer pool, size = 325.0M
110904 10:45:35 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 36700160 bytes
InnoDB: than specified in the .cnf file 0 68157440 bytes!
110904 10:45:35 [ERROR] Plugin 'InnoDB' init function returned error.
110904 10:45:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110904 10:45:35 [ERROR] Unknown/unsupported storage engine: INNODB
110904 10:45:36 [ERROR] Aborting
110904 10:45:36 [Note] D:\MySQL\bin\mysqld: Shutdown complete 展开
110904 10:45:35 InnoDB: The InnoDB memory heap is disabled
110904 10:45:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110904 10:45:35 InnoDB: Compressed tables use zlib 1.2.3
110904 10:45:35 InnoDB: Initializing buffer pool, size = 325.0M
110904 10:45:35 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 36700160 bytes
InnoDB: than specified in the .cnf file 0 68157440 bytes!
110904 10:45:35 [ERROR] Plugin 'InnoDB' init function returned error.
110904 10:45:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110904 10:45:35 [ERROR] Unknown/unsupported storage engine: INNODB
110904 10:45:36 [ERROR] Aborting
110904 10:45:36 [Note] D:\MySQL\bin\mysqld: Shutdown complete 展开
2个回答
展开全部
我在网上找到解决方案:
1、在MY.INI文件中的 [mysqld] 中增加一行
tmpdir="D:/MySQL/data/"
修改后,还是启动不了或者能启动但关机后又出现同样问题,接着我做了第二步,重启正常。
2、删除DATA目录下除数据库文件夹外的其他文件,重启mysql,问题解决。
或者也可以:
先卸载,然后将原来存储数据的目录删除,再重装ok。
1、在MY.INI文件中的 [mysqld] 中增加一行
tmpdir="D:/MySQL/data/"
修改后,还是启动不了或者能启动但关机后又出现同样问题,接着我做了第二步,重启正常。
2、删除DATA目录下除数据库文件夹外的其他文件,重启mysql,问题解决。
或者也可以:
先卸载,然后将原来存储数据的目录删除,再重装ok。
追问
谢谢朋友的关注,我先卸载掉mysql软件,再把d:/mysql/里的所有文件全部删除,然后重新安装mysql,但还是无法启动mysql软件。
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询