Page 1 of 1

Mysql Won't Start

PostPosted: 03. July 2016 21:33
by Coastalguy
Can anyone advise why my Mysql will not start, based on the error logs below? I have just done a clean install of Windows 10, which left Xampp intact after the Windows install, however using the Xampp Control Panel 3.0.2, Apache starts ok, but when clicking on Mysql, the pid appears and disappears, stopping the mysql process.

I am using the same database files as I am on my other PC where both Apache and Mysql run fine. The log entries for the PC where mysql runs ok, is under those below.

Mysql will not run:

160703 15:54:29 [Note] Plugin 'FEDERATED' is disabled.
160703 15:54:29 InnoDB: The InnoDB memory heap is disabled
160703 15:54:29 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160703 15:54:29 InnoDB: Compressed tables use zlib 1.2.3
160703 15:54:29 InnoDB: Initializing buffer pool, size = 16.0M
160703 15:54:29 InnoDB: Completed initialization of buffer pool
160703 15:54:29 InnoDB: highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... nnodb.html
160703 15:54:29 [ERROR] Plugin 'InnoDB' init function returned error.
160703 15:54:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160703 15:54:29 [ERROR] Unknown/unsupported storage engine: InnoDB
160703 15:54:29 [ERROR] Aborting

160703 15:54:29 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Mysql runs ok:

160703 15:46:11 [Note] Plugin 'FEDERATED' is disabled.
160703 15:46:11 InnoDB: The InnoDB memory heap is disabled
160703 15:46:11 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160703 15:46:11 InnoDB: Compressed tables use zlib 1.2.3
160703 15:46:11 InnoDB: Initializing buffer pool, size = 16.0M
160703 15:46:11 InnoDB: Completed initialization of buffer pool
160703 15:46:11 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
160703 15:46:11 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
160703 15:46:11 InnoDB: Waiting for the background threads to start
160703 15:46:12 InnoDB: 1.1.8 started; log sequence number 1599710
160703 15:46:50 [Note] Plugin 'FEDERATED' is disabled.
160703 15:46:50 InnoDB: The InnoDB memory heap is disabled
160703 15:46:50 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160703 15:46:50 InnoDB: Compressed tables use zlib 1.2.3
160703 15:46:50 InnoDB: Initializing buffer pool, size = 16.0M
160703 15:46:50 InnoDB: Completed initialization of buffer pool
160703 15:46:50 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
160703 15:46:50 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
160703 15:46:50 InnoDB: Waiting for the background threads to start
160703 15:46:51 InnoDB: 1.1.8 started; log sequence number 1599710