File PrepareMysqlBackup of Package jsj-installtools

File PrepareMysqlBackup of Package jsj-installtools (Revision 60)

Currently displaying revision 60 , Show latest

#!/bin/bash
. /usr/share/jsjinstalltools/GetVersion
if [ ${VERSION_ID/./} -ge 120 ]; then
  systemctl is-active mysql.service
else
  rcmysql status
fi
RET=$?
if [ $RET != 0 ] ; then
  if [ ${VERSION_ID/./} -ge 120 ]; then
    systemctl start mysql.service
    systemctl enable mysql.service
  else
    rcmysql start
    insserv mysql
  fi
fi
ADMINPW=$1
if [ $ADMINPW != - ]; then
  mysqladmin password $ADMINPW
  MPADMINPW="-p$ADMINPW"
fi
# generate random password of length 16
PASSWRD=$(dd if=/dev/urandom count=14 bs=1 | mimencode | cut -c3-18)

# add crontab entry to dump all databases to /srv/backup/mysql.dump
( crontab -l; echo "0 5 * * * /usr/bin/mysqldump -u mysqlbackup -p$PASSWRD -A --add-drop-database --routines --triggers > /srv/backup/mysql.dump" ) | egrep -v "^#" | crontab -

# create mysql backup directory
mkdir -p /srv/backup

# add two users with limited rights for the backup and Nagios checking
( echo "grant SHOW DATABASES, SELECT, LOCK TABLES, RELOAD on *.* to 'nagiosuser'@'%' identified by 'NidBmT.';"
echo "grant SHOW DATABASES, SHOW VIEW, SELECT, LOCK TABLES, RELOAD on *.* to 'mysqlbackup'@'localhost' identified by '$PASSWRD';"
echo "flush privileges;" ) | mysql -u root $MPADMINPW