Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to fix Error: MySQL shutdown unexpectedly on Xampp due to Plugin 'Aria'

These were the logs:

[ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files [ERROR] Plugin 'Aria' init function returned error. [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

like image 314
German Alfonso Avatar asked Dec 15 '16 18:12

German Alfonso


People also ask

Why does MySQL shut down unexpectedly?

Cause of “Error: MySQL Shutdown Unexpectedly” in XAMPP Apart from corrupted files, improper database shut down, missing files and port changes can also cause this error. When you run MySQL in a webserver, the corrupted files in the mysql/data folder cause MySQL to shut down.


2 Answers

The solution is Removing the aria_log_control file allowed MariaDB to start again. You can find this file in \xampp\mysql\data. Then restart or start xammp.

like image 56
German Alfonso Avatar answered Sep 20 '22 05:09

German Alfonso


If XAMPP generated following logs

[Note] Plugin 'FEEDBACK' is disabled.

[ERROR] j:\xampp\mysql\bin\mysqld.exe: unknown option '--skip-federated'

[ERROR] Aborting

Try to run MySQL with the following command

**mysqld.exe --skip-federated**

Hope this helps!! Good Luck!!

like image 22
Piyush Bansal Avatar answered Sep 22 '22 05:09

Piyush Bansal