#!/bin/sh

source /app/tools/common/lib/.shell_globals

EXEC=1

dd=$(date "+%Y%m%d")
yy=$(date "+%Y")
mm=$(date "+%m")
ldir="/mnt/mysql/backup/mydumper/${dd}/logs"

logit "Start $(date)"

start_time=$(date +%s)

runit "mkdir -p ${ldir}"

runit "cd /app/tools/admin/bin/bman"

runit " \
mysql --login-path=admin -D report -Ne \
\"select db_name from d_db where db_backup=1 order by 1\"| \
parallel -j 4 \"./schema-dumper.sh {} 1>${ldir}/{}.schema-dumper.log 2>&1\" \
"

end_time=$(date +%s)
elapsed=$(( end_time - start_time ))

logit "Complete $(date) - ${elapsed} secs elapsed "