#!/bin/sh

DB=""
USER=""
PASSWORD=""
SCRATCH_DB=""
SCRATCH_USER=""
SCRATCH_PASSWORD=""
SCRATCH_SQL="`dirname $0`/filename.sql"
OUTPUT="`dirname $0`/filename.sql.gz"

set -e
set -x

mysqldump -u $USER -p$PASSWORD $DB | \
  mysql -u $SCRATCH_USER -p$SCRATCH_PASSWORD $SCRATCH_DB

cat "`dirname $0`/scratch.sql" | \
  mysql -u $SCRATCH_USER -p$SCRATCH_PASSWORD $SCRATCH_DB

mysqldump -u $SCRATCH_USER -p$SCRATCH_PASSWORD $SCRATCH_DB | gzip -9 > "$OUTPUT"