Shell script to restart MySQL server if it is killed or not working

in Categories Monitoring last updated April 15, 2019

A simple Linux and Unix bash shell script that would restart your MySQL or MariDB server if it is killed or not working due to ANY reasons.

Share this on:

Start the discussion at Linux/Unix forum

Historical Comment Archive

7 comment

  1. #!/bin/bash
    sub_mysql=’mysql proses down and up’
    MYSQL_START=’/etc/init.d/mysql start’
    #check pid
    if [ $? -ne 0 ]; then
    $MYSQL_START | mail -s “$sub_mysql” $email

  2. Would work better if it check that it could accept commands.

    Something Like….

    mysql -Dmysql -e “SELECT 1;”


  3. Hello

    Thanks for this nice script.
    I’m quite new at server administration, and have 2 questions about your script :
    1- What do you mean by :
    # path to mail program
    MAILCMD=”$(which mail)”
    # path mysqladmin
    MADMIN=”$(which mysqladmin)”

    Do I need to enter the path of both mail and mysql servers ?

    2- If I enter wrong information for the password (and I leave the default intel as question 1), it works …
    So are login and pawd required ?
    Do it works only I 1- is correctly filled ?

    (I’m working with a ovh release 2 (gentoo))


    Have a question? Post it on our forum!