Differences

This shows you the differences between two versions of the page.

--- maintenance:general:tools:mysql_repair.sh [2019/07/16 13:33] – ↷ Page moved from general:tools:mysql_repair.sh to maintenance:general:tools:mysql_repair.sh jbosch
+++ maintenance:general:tools:mysql_repair.sh [2024/07/03 12:31] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+{{indexmenu_n>9}}
+====== mysql_repair.sh ======
+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.
+{{ :general:tools:mysql_process_offline.png?nolink |}}
+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''