Search code examples
phpmysqlwampinnodbwampserver

WampServer 2.4 MySQL instance not starting, icon remains orange


When I start WampServer 2.4 the MySQL instance does not start.

One day it works fine, the next day there was this issue.

I have tried restarting all services, include "innodb_force_recovery = 1" in my.ini and I removed the skip-innodb also in my.ini.

I get the following error:

2014-04-28 16:06:51 4408 [Note] Plugin 'FEDERATED' is disabled.
2014-04-28 16:06:51 13dc 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.
2014-04-28 16:06:51 4408 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-28 16:06:51 4408 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-04-28 16:06:51 4408 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-28 16:06:51 4408 [Note] InnoDB: Not using CPU crc32 instructions
2014-04-28 16:06:51 4408 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-04-28 16:06:51 4408 [Note] InnoDB: Completed initialization of buffer pool
2014-04-28 16:06:51 13dc  InnoDB: Operating system error number 3 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2014-04-28 16:06:51 13dc  InnoDB: File name C:\mysql\data\ibdata1
2014-04-28 16:06:51 13dc  InnoDB: File operation call: 'create' returned OS error 103.
2014-04-28 16:06:51 13dc  InnoDB: Cannot continue operation.

I have searched for both Operating system error number 3 and OS error 103 and I cannot find an answer for the problem.

I got the ibdata1 file, but since I got data in my databases, I do not want to delete it and let WampServer recreate it.

It is not possible to log on to phpMyAdmin, but I can access the Localhost.

Also, I am pretty sure I have not changed anything in the folder structure.


Solution

  • Resolved

    I just wanted to let everyone know, that I don't have this problem any longer.

    The problem was caused by enabling InnoDB.

    The problem disappeared wheh I reinstalled WampServer, and after that I was able to enable InnoDB with no problem at all.