Script to automatically start mysql

The following script is used to  start mysql automatically when it is failed or stopped on the server.

You can set 2 min cron “*/2 * * * * /bin/sh /root/automysqlstart.sh” and it restart the mysql automatically.

#!/bin/bash

#Checking whether MySQL is alive or not

if mysqladmin ping | grep -q "alive"; then

echo "MySQL is up"

else

/etc/init.d/mysqld restart

fi