ApacheFriends / xampp-build

XAMPP Build system
Apache License 2.0
41 stars 10 forks source link

XAMPP Control Panel MySQL/MariaDB Clean Shutdown (possible solution) #16

Closed AndrewJDFerguson closed 1 year ago

AndrewJDFerguson commented 1 year ago

Not sure if this could be moved to the proper repository, so I'm going to close this one and open a new on in the xampp-control-windows repository.

Quite a few Windows users are regularly experiencing issues with MySQL/MariaDB getting corrupted between XAMPP Control Panel runs. This appears to have started happening around a year back, but that is my best recollection. If you look at the Apache Friends Windows Forum (https://community.apachefriends.org/f/viewforum.php?f=16) you can see a number of questions related to database corruption.

My solution, and one I recommend on the forum, is to configure at least MySQL/MariaDB to run as Windows Services. This has worked for me without fail since early last year. Recently, another user suggested a way to "properly" shutdown MySQL/MariaDB from the XAMPP Control Panel Shell by issuing "mysqladmin shutdown -uroot". I have not verified this, but perhaps when MySQL/MariaDB are not configured to run as Windows Services, this approach could be used when the "stop" action is clicked.

Thank you.