xampp windows mariadb not starting
With the help of @RiggsFolly, the following solved my issue.
- Open cmd.
- In cmd, go to xampp/mysql/data folder. In my case, I did the following
cd C:\xampp\mysql\data
- Run
aria_chk -r
in that directory for all.MAI
tables in the mysql subfolder. In my case,..\bin\aria_chk -r mysql\*.MAI
- Delete all
aria_log.########
files. They are present in the C:\xampp\mysql\data folder. I just renamed them for just in case (addedold_
in the beginning of their names). - Start xampp again and it should be working.
I tried with the solution of answer 1, it look great but in my case from cmd I got an error of permission denied for files xampp\mysql\data\mysql*.mai.Instead I found another solution.
ATTENTION: the drawback is that you lose the users created with database privileges, in my case it is not a big damage because I only had four sites locally, and it was easy for me to recreate the users in phpmyadmin.
The whole tour takes 5 minutes and you work on the folders and files, even without cmd:
- delete all xampp\mysql\data\mysql.mai files
- copy all .mai files from mysql backup folder: xampp\mysql\backup\mysql*.mai
- delete the aria_log.######## files in the xampp\mysql\data folder
- restart xampp: It works!
- recreate the privileged users of each database in phpmyadmin