XAMPP keeps failing due to corrupted database 'db'

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

XAMPP keeps failing due to corrupted database 'db'

Postby dhargreaves » 07. June 2021 00:37

I have been a happy user of the XAMPP package for many years, but have had a repeatedly sad experience after a period of time which is that I go to start my LOCALHOST environment and the phpmyadmin tool and discover that I can't access user accounts and get a message that the 'db' database is corrupt.

Any assistance would be greatly appreciated...thanks to you all!

-David
dhargreaves
 
Posts: 1
Joined: 16. May 2021 19:57
XAMPP version: 7.4.8 x64
Operating System: windows 10 pro x64

Re: XAMPP keeps failing due to corrupted database 'db'

Postby ies » 11. July 2022 12:06

I have the same problem too. I use XAMPP for many years without any problem. Recently I installed XAMPP 3.3.0 in my new laptop with Windows 11 and every second or third time I start MySQL the database is corrupted. I have to to the trick described in the following link as a temporary solution.
https://stackoverflow.com/questions/56865620/mysql-stops-unexpectedly
ies
 
Posts: 3
Joined: 11. July 2022 12:02
XAMPP version: 3.3.0
Operating System: Windows 11

Re: XAMPP keeps failing due to corrupted database 'db'

Postby Altrea » 12. July 2022 08:55

Register the MariaDB windows services. Then the xampp control panel uses the services to start and stop MariaDB. That is the only valid method known to prevent MariaDB from corrupting.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: XAMPP keeps failing due to corrupted database 'db'

Postby ies » 12. July 2022 09:57

Ok, I applied your idea and I will wait for some days to see if the problem will appear again or not. Thank you for the quick answer.
ies
 
Posts: 3
Joined: 11. July 2022 12:02
XAMPP version: 3.3.0
Operating System: Windows 11

Re: XAMPP keeps failing due to corrupted database 'db'

Postby Froosh » 12. July 2022 14:47

What Altrea recommends has worked for me for months now. Before that I was getting database corruption regularly. Once I started running MariaDB as a Windows Service, my environment has been solid.
User avatar
Froosh
 
Posts: 138
Joined: 27. March 2022 17:56
XAMPP version: 8.2.0
Operating System: Windows 11 Pro

Re: XAMPP keeps failing due to corrupted database 'db'

Postby ies » 15. July 2022 10:46

After a few days having applied the suggestion of Altrea it seems that the problem is solved. So thanks for the solution of Altrea (and the confirmation of Froosh), I can work better now.
ies
 
Posts: 3
Joined: 11. July 2022 12:02
XAMPP version: 3.3.0
Operating System: Windows 11

Re: XAMPP keeps failing due to corrupted database 'db'

Postby smuffatti » 06. September 2022 14:31

Hey, I also have this issue where I have to preform the trick listed by ies every few days. I'm a little confused on how to register the MariaDB windows services on Windows 11 as Altrea suggests. Any guidance would be appreciated.
smuffatti
 
Posts: 2
Joined: 06. September 2022 14:27
XAMPP version: 3.3.0
Operating System: Windows 11

Re: XAMPP keeps failing due to corrupted database 'db'

Postby Altrea » 06. September 2022 18:09

smuffatti wrote:I'm a little confused on how to register the MariaDB windows services on Windows 11 as Altrea suggests.

open your xampp control panel with elevated Administrator rights (rightclick -> run as Administrator)
then click on the red X button next to mysql
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: XAMPP keeps failing due to corrupted database 'db'

Postby smuffatti » 08. September 2022 16:55

So amazing and simple. I can't believe I missed that. Thank you very much.
smuffatti
 
Posts: 2
Joined: 06. September 2022 14:27
XAMPP version: 3.3.0
Operating System: Windows 11


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 108 guests