#!/bin/sh

# IDF (iforbes@zsd.co.za) 10 Oct 2004
# dump mysql databases to facilitate backup
# IDF (iforbes@zsd.co.za) 29 Mar 2010
# only dump directories not other files in ~mysql dir
# cuts down on errors and noise
# IDF: Updated 2015-03-04
# IDF: Updated 2015-05-29

# Note requires .my.cnf file in /root directory with mysql username and password.

# Exit quitely if mysql is not installed
test  -x /usr/bin/mysqldump || exit 0

echo doing backup

MYSQLDIR="/var/lib/mysql"

# create backup directory if required
if [ ! -d /var/backups/mysql ]; then
  mkdir -p /var/backups/mysql
fi

ls -1 -d $MYSQLDIR/* |

while read DATABASEDIR
do
  #! echo $DATABASEDIR
  if test -d $DATABASEDIR
    then
      DATABASE=`basename $DATABASEDIR`
      echo `date` doing $DATABASE
      #mysqldump $DATABASE | gzip > /var/backups/mysql/${DATABASE}.gz
      mysqldump $DATABASE > /var/backups/mysql/${DATABASE}
  fi
done