#!/bin/bash

DB_host="localhost"
DB_user=""
DB_pass=""
DB="nzedb"
DIR=$DB
DB_FULL=`mysql --user=$DB_user -p$DB_pass -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`

[ -n "$DIR" ] || DIR=.
test -d $DIR || mkdir -p $DIR

echo
echo "Dumping tables into separate SQL command files for database '$DB"

tbl_count=0

for t in $(mysql -NBA -h $DB_host -u $DB_user -p$DB_pass -D $DB -e 'show tables' |grep -v binaries_ |grep -v partrepair_ |grep -v parts_ |grep -v collections_*)
do
#    echo "DUMPING TABLE: $t"
    mysqldump --opt --single-transaction --quick -h $DB_host -u $DB_user -p$DB_pass --routines $DB $t | gzip --rsyncable > $DIR/$t.sql.gz
    (( tbl_count++ ))
done


echo "$tbl_count tables dumped from database '$DB'"

echo
echo "Dump Started on $DB_FULL"

for db_full in $DB_FULL; do
  echo "$db_full backing up"
      mysqldump --opt --single-transaction --quick --user=$DB_user -p$DB_pass --routines --databases $db_full | gzip --rsyncable > "$db_full.gz"
   echo "Finished up $db_full"
     done

echo "Completed mysqldump"