SQL Corruption after running xampp

[AndyTheAstronomer]

Hello all,

I am experiencing SQL table corruption problems.

I am running Joomla v3.10 under xampp (version 7) with php 7.2.3.1 which I restored from a backup. I run localhost and all is fine. However, the *next* time I run it I find that tables in the MySQL database are now corrupt. Restoring the backup and running localhost again is fine, but, again the next time I run it the same thing happens.

I should point out that this has only happened since I upgraded from Windows 10 to Windows 11.

One suggestion I tried was to run the Xampp control panel as Administrator, but this made no difference.

Does anybody have any idea if this is fixable, and if so how?

If not, can anybody point me to some comprehensive instructions on how to upgrade xampp and restore my existing Joomla installation, given that xampp now uses MariaDB and not MySQL? I have not upgraded xampp until now because, well, it worked, and if it ain't broke don't fix it! But now....it doesn't work.

Any help with resolving this would be much appreciated.

Thanks in advance

Andy.

[Froosh]

You will need to repair you databases. Search the forums for related posts relevant to the errors you are encountering. Whatever you do, make a copy of the existing MySQL data folder. Solving the MySQL issue usually involves executing a few commands in console windows.

After you get your databases back online, the answer is not so much running the XAMPP Control Panel as an Administrator, but rather running it as an Administrator so that you can enable running at least MySQL as Windows Service. You cannot do that without running the XAMPP Control Panel as an Administrator.

[AndyTheAstronomer]

Thank you so much! I will do some reading on the forums as you suggest. I'm very grateful for your help.

All the best

Andy.

[AndyTheAstronomer]

One thing though: even if I repair the tables, the same corruption will occur the next time I run xampp. Do you have any idea what might be causing it and what the fix might be?

[Nobbie]

Do you have any idea what might be causing it and what the fix might be?

He already told it to you (and he did it approx. 1.000 times here):

running it as an Administrator so that you can enable running at least MySQL as Windows Service. You cannot do that without running the XAMPP Control Panel as an Administrator.

Run MariaDB as WIndows service.

If you run MariaDB as Windows service, Windows itself shuts down everything "smoothly". If you shutdown MariaDB on yourself (via ControlPanel - or, even worse, by simply shutting down the PC), there seems to be a problem with cached data. This has been discussed definately more than 1.000 times in this forum. Its already annoying for already many years, all users ask the same question. Again and again and again and again. Actually, its a pain.

For your understanding: Apache, MariaDB etc. are server programs. Servers are meant to run for a long time and stable. They are NOT designed to start and shutdown on a daily base. Its a good question, if its really a good idea to install Apache etc. on a private PC and treat it like games. Its not a game. I definately recommend NOT to run Xampp on private PCs, instead go for a professional Webhoster. There are plenty of webhosters, all with 24/7 runtime and server uptime, and many of them cheap (starting at 1 oder 2 USD or Euro per month). They also provide professional backups and in the end, the electricity for the private computer will certainly cost you more than the cost of an entry-level web host. You also get a working email account, a problem that even many Xampp users can't solve.

[AndyTheAstronomer]

Yes, but this is not MariaDB. It's MySQL, as I said in my post. And it was working perfectly until Windows 11.

In addition, my Joomla site was never intended to be hosted. It was always going to remain on my PC as a web interface. It's an educational resource I've been building for the last 6 years, and at 1.3 TB it's far too big and expensive to host anyway.

[Altrea]

Yes, but this is not MariaDB. It's MySQL, as I said in my post

That is odd.

Your profile says you are using XAMPP 7.2.10 which comes with PHP 7.2.10 and MariaDB 10.1.36. no mysql.

Your topic says you are using PHP 7.2.3.1. There is no php version existing using this version number. There is no XAMPP version 7.2.3.1/7.2.3-1, only XAMPP 7.2.3 (7.2.3-0) and that version comes with PHP 7.2.3 and MariaDB 10.1.31. again, no mysql.

There is a XAMPP version 7.2.31 which comes with PHP 7.2.31 and MariaDB 10.4.11.

In fact XAMPP switches to MariaDB since versions v5.5.30 / v5.6.14 which was released before PHP 7.0 was released.

[AndyTheAstronomer]

Thanks Altrea. Well, that is certainly very odd, as I am definitely running MySQL. I dont understand that at all. I definitely downloaded it from the xampp site.

Many thanks for your help!

[AndyTheAstronomer]

Hi guys, thanks to everybody who helped me in this thread - it really is much appreciated.

Having installed Apache & MySQL as Windows services, everything is fine with no data corruption.

Thanks for taking the time to help me.

Andy.

[Altrea]

Well, that is certainly very odd, as I am definitely running MySQL. I dont understand that at all. I definitely downloaded it from the xampp site.

so what mysql version are you running? you can see that in the server signature in phpmyadmin or the command line interface.