search

ApacheFriends / xampp-control-windows

XAMPP control panel for Windows
Apache License 2.0
16 stars 6 forks source link

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

Open AndrewJDFerguson opened 1 year ago

AndrewJDFerguson commented 1 year ago

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.

beltran-rubo commented 1 year ago

Thanks for posting it. We have limited time to invest on this but we will check if there is any required change into the installer to avoid this issue. Any contribution to the repository will be welcome! Thanks