If you ever run into a situation that MariaDB (mysql) isn't running and doesn't want to start anymore, the script mysql_repair.sh
can save your day.
First of all, verify that mysqld is indeed not working by using go ps
, which will show the following if the process is offline.
If indeed offline, the mysql_repair.sh
script can be run, which will troubleshoot and try to fix the situation. The error log can be viewed as well, which is found at /var/opt/mysql/<hostname.domain>.err
.
Once the repair script is finished the daemon will be started automatically and other demons that depend on it will be started as well by yce_psmon.
The script is located in: /opt/yce/system/mysql_repair.sh