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

============================

Leave a Comment