#!/bin/sh

source /home/devorch/collab/jgetter/perllib/lib/shell_globals

TABLE=$1
EXEC=$2

dd=$(date "+%Y%m%d")
yy=$(date "+%Y")
mm=$(date "+%m")
of="abacus-prod-${TABLE}-${dd}.sql"

runit "mysqldump --login-path=abacus_prod \
--no-create-db \
--routines \
--verbose \
--skip-add-locks \
--skip-disable-keys \
--set-gtid-purged=OFF \
royalty_accounting ${TABLE}
>${of}"

runit "perl -pi -e 's/ra-deploy/jgetter/g' ${of}"

runit "mysql --login-path=abacus_qa -D royalty_accounting -A < ${of}"
# --databases royalty_accounting \
# --ignore_table=royalty_accounting.report_custom \
# --ignore_table=royalty_accounting.statement_attachment \