xampp windows mariadb not starting xampp windows mariadb not starting windows windows

xampp windows mariadb not starting


With the help of @RiggsFolly, the following solved my issue.

  1. Open cmd.
  2. In cmd, go to xampp/mysql/data folder. In my case, I did the following cd C:\xampp\mysql\data
  3. Run aria_chk -r in that directory for all .MAI tables in the mysql subfolder. In my case, ..\bin\aria_chk -r mysql\*.MAI
  4. Delete all aria_log.######## files. They are present in the C:\xampp\mysql\data folder. I just renamed them for just in case (added old_ in the beginning of their names).
  5. 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:

  1. delete all xampp\mysql\data\mysql.mai files
  2. copy all .mai files from mysql backup folder: xampp\mysql\backup\mysql*.mai
  3. delete the aria_log.######## files in the xampp\mysql\data folder
  4. restart xampp: It works!
  5. recreate the privileged users of each database in phpmyadmin