Advertisement
cyber2friends

MySQL Auto Restart (for DirectAdmin)

Oct 17th, 2017
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.31 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. USER="da_admin"
  4. PASSWD=$(grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2)
  5.  
  6. mysql --user="${USER}" --password="${PASSWD}" -e exit 2>/dev/null
  7. SQLSTATUS=`echo $?`
  8.  
  9. if [ $SQLSTATUS -ne "0" ]; then
  10. echo MySQL is down!
  11. /usr/bin/killall mysqld
  12. /etc/init.d/mysqld restart
  13. fi;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement