Hello,
I need a Bash Script To Restart mysql, can someone help please ?
Thank you very much!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×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
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
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:
This restarts every minute:
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:
PS add this if you want to stop it emailing you the results of every time cron runs the script: