一切都工作正常，但突然MySQL停止工作，并在启动前意外关闭。我尝试了基于其他堆栈溢出答案的各种解决方案。
1.我删除了C:\xampp\mysql\data中的ibdata1并重新启动XAMPP =未解决
1.我删除了所有自定义数据库文件夹，仅保留了最初安装时存在的文件夹=未解决
错误日志文件显示：
2016-02-09 16:47:08 1430 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
160209 16:47:08 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160209 16:47:08 [Note] InnoDB: The InnoDB memory heap is disabled
160209 16:47:08 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160209 16:47:08 [Note] InnoDB: Memory barrier is not used
160209 16:47:08 [Note] InnoDB: Compressed tables use zlib 1.2.3
160209 16:47:08 [Note] InnoDB: Not using CPU crc32 instructions
160209 16:47:08 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160209 16:47:08 [Note] InnoDB: Completed initialization of buffer pool
160209 16:47:08 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
160209 16:47:08 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
160209 16:47:08 [Note] InnoDB: Database physically writes the file full: wait...
160209 16:47:08 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
160209 16:47:08 [ERROR] Plugin 'InnoDB' init function returned error.
160209 16:47:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160209 16:47:08 [Note] Plugin 'FEEDBACK' is disabled.
160209 16:47:08 [ERROR] Unknown/unsupported storage engine: InnoDB
160209 16:47:08 [ERROR] Aborting
160209 16:47:08 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
2条答案
按热度按时间rekjcdws1#
在不同的论坛上问过之后，我没有找到解决方案。我不得不重新安装，然后又发生了。然后我在stackoverflow的某个地方找到了一个答案，不以管理员身份启动xampp并关闭它会导致mysql随着时间的推移而损坏。所以去属性，并确保它总是以管理员身份运行。希望其他找到这背后原因的人能得到答案。
l0oc07j22#
有一个简单的方法可以解决这个问题，就是从MySql安装目录中删除,,下面,,的两个文件**。