#!/bin/bash

################################################################################
#
# For now, use mysqldump to dump the tables to CREATE/INSERT statements.
#
# Long term, you might want to use something to create a "snapshot" of the
# the mysql data files directly (for example, mysqlhotcopy).
#
# See: perldoc /usr/bin/mysqlhotcopy
#
################################################################################


DATE=`date '+%G%m%d'`

DUMPDIR="/app/backup/snapshots"

echo `date` "-- Started DB dump for $DATE"

# skipping wmg for now
for DB in RSCOMMON C_EPITAPH C_ALLIGATOR C_VIRTUAL_LABEL C_BIG_FISH C_LUMBERJACK_MORDAM C_KOCH_RECORDS C_KOCH_DISTRIBUTION C_LAUGH C_DIGITALPRESSURE C_INSTINCT C_GNP_CRESCENDO C_DUALTONE C_VP_RECORDS C_OH_BOY C_SMITHSONIAN C_SUNNYSIDE C_BEGGARS C_MATADOR C_CURB C_ARHOOLIE C_COMPASS C_BIG_DADDY C_PIAS C_HARMONIA_MUNDI C_RAZOR_AND_TIE C_TOMMYBOY C_NACIONAL C_SHERIDANSQUARE C_SANCTUARY C_ACONY C_FOXMUSIC C_WORLDSFAIR C_TOUCHANDGO C_NITRO C_V2MUSIC C_BLINDPIG C_CONCORD C_GO_DIGITAL C_AUDIOBEE C_IDEA C_ICERECORDS C_FESTIVALFIVE C_MARDIGRAS C_MADACY
do
  FILE="$DUMPDIR/$DB.$DATE.sql"

  # flush the tables to force any pending writes
  mysqladmin -uroot flush-tables

  echo `date` "-- Dumping $DB"
  mysqldump --extended-insert -uroot $DB > $FILE

  echo `date` "-- Gzipping $DB"
  /bin/gzip $FILE

done

echo `date` "-- Finished DB dump for $DATE"