Mysql service was down in one of the vps with following error in the mysql log

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with –with-aria-tmp-tables
[ERROR] Aborting
mysqld: File ‘/var/lib/mysql/aria_log.00003041’ not found (Errcode: 2 “No such file or directory”)
[ERROR] mysqld: Aria engine: log initialization failed
[ERROR] Plugin ‘Aria’ init function returned error.
[ERROR] Plugin ‘Aria’ registration as a STORAGE ENGINE failed.

 

Moved the /var/lib/mysql/aria_log_control file and restarted the mysql service.

• CentOS
• Linux
• MySQL