MySQL not starting after updating xampp

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL not starting after updating xampp

Postby rhammer54 » 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
rhammer54
 
Posts: 3
Joined: 08. April 2018 19:46
XAMPP version: 3.2.2
Operating System: Windows 10 64bit Home edition

Re: MySQL not starting after updating xampp

Postby Nobbie » 08. April 2018 23:59

As there is no upgrade/update procedure for Xampp, neither any upgrade package, nor any tool, you can only fully deinstall Xampp and then fully install a new Xampp (what of course results in loss of all databases, scripts, dovuments, configuration tweaks): what do you mean by "updating Xampp"??
Nobbie
 
Posts: 10281
Joined: 09. March 2008 13:04

Re: MySQL not starting after updating xampp

Postby rhammer54 » 09. April 2018 09:28

OK I uninstalled my previous xampp installation from the uninstall link on windows control panel.
My databases are stored on a separate drive to the xampp installation and are still present on that drive.
Then went to apache friends and downloaded the latest version of xampp (version 3.2.2) which I installed to a directory C:/xampp2018/
On completion of the installation I clicked start on the apache link and start on the mysql link, both started OK.
I then stopped both and edited the configuration files by clicking the Config links on the xampp control panel
Apache then worked fine and was reading ok websites wrtten with php & html.
On the my.ini config I edited the liine to read datadir = "H:/mysql-data" as my databases are stored on drive H in folder mysql-data. I also edited the line
innodb_data_home_dir = "H:/mysql-data" as again my databases are of the type innodb and are those stored on H:/mysql-data.

But starting Mysql now causes it to crash out as described.
Hopefully the above and my original post can show what I have done wrong???

regards Bob
rhammer54
 
Posts: 3
Joined: 08. April 2018 19:46
XAMPP version: 3.2.2
Operating System: Windows 10 64bit Home edition

Re: MySQL not starting after updating xampp

Postby rhammer54 » 09. April 2018 14:07

I have solved my problem by recreating the databases by importing saved sql files through phpmyadmin, only issue is that my databases now reside in the default folders so wont get backed up automatically but no big deal?
Next time I am prompted to update xampp I will ignore - if it aint broke dont fix it???? Not sure it actually updated either as am still on a build claiming compiled 12th Nov 2015 - I thought thats what I had anyway.

regards Bob
rhammer54
 
Posts: 3
Joined: 08. April 2018 19:46
XAMPP version: 3.2.2
Operating System: Windows 10 64bit Home edition


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 46 guests