Hi all,
We run a Windows 10 Pro x64 pc as a server. MySQL was installed and ran
fine. No problems. Recently I tried to update it with the 8.0.24
installer. Everything worked fine, except that when applying the configuration, the server won't start. I waited quite a long time,
untill I got a popup with the message "MySQL server 8.0.24 configuration
is taking longer than expected".
Then I stopped the proces and uninstalled the server and it's components completely.
I installed a new server, 8.0.24. Settings: Developement (default). Same problem, installation works fine but the server won't start. After
waiting a long time I interrupted the process and uninstalled the server again and all of it's components. Then I installed the server again, but
now as MySQL server only.
The same problem ocurred.
What can be wrong? What can I do to make the server run?
On 10/05/2021 11.19, Fokke Nauta wrote:
Hi all,
We run a Windows 10 Pro x64 pc as a server. MySQL was installed and
ran fine. No problems. Recently I tried to update it with the 8.0.24
installer. Everything worked fine, except that when applying the
configuration, the server won't start. I waited quite a long time,
untill I got a popup with the message "MySQL server 8.0.24
configuration is taking longer than expected".
Then I stopped the proces and uninstalled the server and it's
components completely.
I installed a new server, 8.0.24. Settings: Developement (default).
Same problem, installation works fine but the server won't start.
After waiting a long time I interrupted the process and uninstalled
the server again and all of it's components. Then I installed the
server again, but now as MySQL server only.
The same problem ocurred.
What can be wrong? What can I do to make the server run?
I suggest you start your event viewer and look for events in there, sure
it had been easier if it has been searchable, but sadly closed source products ain't that user friendly.
Stability with the combination MySQL and MS-Windows have been bad, I
would recommend to use another OS to run it on, for local testing WSL
seems to work quite ok.
I would do recommend you to test MariaDB, go for the 10.x version, it's
open with it's bug fixes which Oracle ain't. Still they are more or less
just drop in replacements for each other.
On 10/05/2021 11:39, J.O. Aho wrote:
On 10/05/2021 11.19, Fokke Nauta wrote:
Hi all,
We run a Windows 10 Pro x64 pc as a server. MySQL was installed and
ran fine. No problems. Recently I tried to update it with the 8.0.24
installer. Everything worked fine, except that when applying the
configuration, the server won't start. I waited quite a long time,
untill I got a popup with the message "MySQL server 8.0.24
configuration is taking longer than expected".
Then I stopped the proces and uninstalled the server and it's
components completely.
I installed a new server, 8.0.24. Settings: Developement (default).
Same problem, installation works fine but the server won't start.
After waiting a long time I interrupted the process and uninstalled
the server again and all of it's components. Then I installed the
server again, but now as MySQL server only.
The same problem ocurred.
What can be wrong? What can I do to make the server run?
I suggest you start your event viewer and look for events in there,
sure it had been easier if it has been searchable, but sadly closed
source products ain't that user friendly.
Stability with the combination MySQL and MS-Windows have been bad, I
would recommend to use another OS to run it on, for local testing WSL
seems to work quite ok.
I would do recommend you to test MariaDB, go for the 10.x version,
it's open with it's bug fixes which Oracle ain't. Still they are more
or less just drop in replacements for each other.
Hi,
Thanks for your quick response.
I just found the cause. Allthough during the installation I specified a special database location, which I replaced with the original data after
the installation, MySQL didn't see the databases. I found that it looked
at a different location. After replacing those files with the original
ones, it works fine.
Using another OS is no option, unfortunately. There are many good
Linuxes around, but my knowledge of them is too little to fully use them.
Fokke
On 10-5-2021 16:24, Fokke Nauta wrote:
On 10/05/2021 11:39, J.O. Aho wrote:
On 10/05/2021 11.19, Fokke Nauta wrote:
Hi all,
We run a Windows 10 Pro x64 pc as a server. MySQL was installed and
ran fine. No problems. Recently I tried to update it with the 8.0.24
installer. Everything worked fine, except that when applying the
configuration, the server won't start. I waited quite a long time,
untill I got a popup with the message "MySQL server 8.0.24
configuration is taking longer than expected".
Then I stopped the proces and uninstalled the server and it's
components completely.
I installed a new server, 8.0.24. Settings: Developement (default).
Same problem, installation works fine but the server won't start.
After waiting a long time I interrupted the process and uninstalled
the server again and all of it's components. Then I installed the
server again, but now as MySQL server only.
The same problem ocurred.
What can be wrong? What can I do to make the server run?
I suggest you start your event viewer and look for events in there,
sure it had been easier if it has been searchable, but sadly closed
source products ain't that user friendly.
Stability with the combination MySQL and MS-Windows have been bad, I
would recommend to use another OS to run it on, for local testing WSL
seems to work quite ok.
I would do recommend you to test MariaDB, go for the 10.x version,
it's open with it's bug fixes which Oracle ain't. Still they are more
or less just drop in replacements for each other.
Hi,
Thanks for your quick response.
I just found the cause. Allthough during the installation I specified
a special database location, which I replaced with the original data
after the installation, MySQL didn't see the databases. I found that
it looked at a different location. After replacing those files with
the original ones, it works fine.
Using another OS is no option, unfortunately. There are many good
Linuxes around, but my knowledge of them is too little to fully use them.
Fokke
But MariaDB is not an OS,
Just as MySQL is not an OS.
Ubuntu, or Debian, that are OS.
You definitely need start reading some of the articles found here: https://www.google.com/search?q=mysql+vs+mariadb
😉
He suggested to use a different OS: "Stability with the combination MySQL and MS-Windows have been bad, I
would recommend to use another OS to run it on, for local testing WSL
seems to work quite ok."
On 10/05/2021 21:03, Luuk wrote:
On 10-5-2021 16:24, Fokke Nauta wrote:
But MariaDB is not an OS,
Just as MySQL is not an OS.
Ubuntu, or Debian, that are OS.
He suggested to use a different OS: "Stability with the combination
MySQL and MS-Windows have been bad, I
would recommend to use another OS to run it on, for local testing
WSL seems to work quite ok."
On 11/05/2021 09.13, Fokke Nauta wrote:
On 10/05/2021 21:03, Luuk wrote:
On 10-5-2021 16:24, Fokke Nauta wrote:
But MariaDB is not an OS,
Just as MySQL is not an OS.
Ubuntu, or Debian, that are OS.
He suggested to use a different OS: "Stability with the combination
MySQL and MS-Windows have been bad, I
would recommend to use another OS to run it on, for local testing
WSL seems to work quite ok."
I had two suggestions, one was using MariaDB and and another one to
switch OS.
Myself at work I use WSL as we have a closed source OS on our
development machines, this gives the simplicity of installing programs
with a package manager (no need to go to shady websites and download binaries) and of course configuration a lot more like in production environment.
I do recommend you to learn Linux, as that will be more and more
required knowledge. A good starting point can be microsofts WSL
introduction: https://docs.microsoft.com/en-us/learn/modules/get-started-with-windows-subsystem-for-linux/
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 54:31:40 |
Calls: | 6,650 |
Calls today: | 2 |
Files: | 12,200 |
Messages: | 5,330,627 |