Bash Script To Restart mysql Ubuntu 14.04

July 10, 2014 23.5k views
calithos
By:
calithos

Hello,

I need a Bash Script To Restart mysql, can someone help please ?

Thank you very much!

1 comment
  • mattjarvis November 6, 2015

    Hey - I had this issue, but I only wanted to restart mysql if it had stopped.

    To simply restart MySQL you can add the following to the root CRONTAB:

    sudo crontab -e

    This restarts every minute:

    */1 * * * * run-one sudo service mysql restart

    If you want to check if MySQL is running first, and start it if it isn't, then you could add this to the crontab:

    */1 * * * * run-one sudo service mysql start

    PS add this if you want to stop it emailing you the results of every time cron runs the script:

    >/dev/null 2>&1
IE:
*/1 * * * * run-one sudo service mysql start >/dev/null 2>&1
Log In to Comment
2 Answers
calithos July 10, 2014

Kamal,

my MYSQL is down 10 times for day, for this reason I need the bash script.

I've this 2 bash script in the /root : 

#!/bin/sh

ps auxw | grep apache2 | grep -v grep > /dev/null

if [ $? != 0 ]
then
        /etc/init.d/apache2 start > /dev/null
fi


#!/bin/bash
if [[ ! "$(service mysql status)" =~ "start/running" ]]
then
    service mysql start
fi

None working properly

You can help me please?
Thank you very much

Reply
  • kamaln7 MOD July 11, 2014

    I would recommend finding out why MySQL is crashing in the first place and solving that instead of working around it and just restarting it and then having it crash again.

    Check MySQL's error log, what's the output of this command?

    sudo tail -30 /var/log/mysql.err
kamaln7 MOD July 10, 2014

You can restart MySQL by running sudo service mysql restart. You don't need a bash script, you can just run that command. Is that what you need?

Reply
Have another answer? Share your knowledge.