MySQL not starting after updating xampp
Posted: 08. April 2018 19:55
I have updated xampp to version 3.2.2 today.
On updating I can start apache and mysql and both run.
However when I change the datadir & innodb_data_home_dir in my.ini to where my mysql databases are then when I start mysql it crashes out.
The following is the log:-
2018-04-08 19:25:55 12648 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-04-08 19:25:55 12648 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-08 19:25:55 12648 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-04-08 19:25:55 12648 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-04-08 19:25:55 12648 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-04-08 19:25:55 12648 [Note] InnoDB: Using generic crc32 instructions
2018-04-08 19:25:56 12648 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-04-08 19:25:56 12648 [Note] InnoDB: Completed initialization of buffer pool
2018-04-08 19:25:56 12648 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-08 19:25:56 12648 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 1835107 in the ib_logfiles!
2018-04-08 19:25:56 12648 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2018-04-08 19:25:58 12648 [Note] InnoDB: 128 rollback segment(s) are active.
2018-04-08 19:25:58 12648 [Note] InnoDB: Waiting for purge to start
2018-04-08 19:25:58 12648 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-83.0 started; log sequence number 1835107
2018-04-08 19:25:58 11716 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-04-08 19:25:58 12648 [Note] Plugin 'FEEDBACK' is disabled.
2018-04-08 19:25:58 12648 [Note] Server socket created on IP: '::'.
2018-04-08 19:25:58 12648 [Note] c:\xampp2018\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.31-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
anyone know what I need to do to get mysql running again - I am a complete newby in respect of configuring mysql?
regards Bob
On updating I can start apache and mysql and both run.
However when I change the datadir & innodb_data_home_dir in my.ini to where my mysql databases are then when I start mysql it crashes out.
The following is the log:-
2018-04-08 19:25:55 12648 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-04-08 19:25:55 12648 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-08 19:25:55 12648 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-04-08 19:25:55 12648 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-04-08 19:25:55 12648 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-04-08 19:25:55 12648 [Note] InnoDB: Using generic crc32 instructions
2018-04-08 19:25:56 12648 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-04-08 19:25:56 12648 [Note] InnoDB: Completed initialization of buffer pool
2018-04-08 19:25:56 12648 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-08 19:25:56 12648 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 1835107 in the ib_logfiles!
2018-04-08 19:25:56 12648 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2018-04-08 19:25:58 12648 [Note] InnoDB: 128 rollback segment(s) are active.
2018-04-08 19:25:58 12648 [Note] InnoDB: Waiting for purge to start
2018-04-08 19:25:58 12648 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-83.0 started; log sequence number 1835107
2018-04-08 19:25:58 11716 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-04-08 19:25:58 12648 [Note] Plugin 'FEEDBACK' is disabled.
2018-04-08 19:25:58 12648 [Note] Server socket created on IP: '::'.
2018-04-08 19:25:58 12648 [Note] c:\xampp2018\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.31-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
anyone know what I need to do to get mysql running again - I am a complete newby in respect of configuring mysql?
regards Bob