dump-databases.sh

#!/bin/bash
CURRENT_DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null && pwd )"
source $CURRENT_DIR/config.ini

# This script dump all databases to the corresponding user dir.

DB_COUNT=0

echo "$(date +'%F %T') #################### DUMP MYSQL DATABASES TO CORRESPONDING USER DIR ####################"
# Get user list
while read USER ; do
  # Create dir where the user databases will be stored
  DESTINATION=$HOME_DIR/$USER/$DB_DUMP_DIR_NAME
  mkdir -p $DESTINATION
  # Clean destination
  rm -f $DESTINATION/*
  # Get databases
  while read DATABASE ; do
    mysqldump $DATABASE --opt --routines | gzip > $DESTINATION/$DATABASE.sql.gz
    echo "$(date +'%F %T') -- $DATABASE > $DESTINATION/$DATABASE.sql.gz"
    # Fix permissions
    chown -R $USER:$USER $DESTINATION
    let DB_COUNT++
  done < <(v-list-databases $USER | cut -d " " -f1 | awk '{if(NR>2)print}')
done < <(v-list-users | cut -d " " -f1 | awk '{if(NR>2)print}')

echo "$(date +'%F %T') ########## $DB_COUNT DATABASES SAVED ##########"
echo