#!/bin/tcsh

# This is big stuff that doesn't change often.  We can save this and load this
# at almost any time.  More precisely, we're not that worried about
# syncrhonizing with the replication.

mysqldump -uroot -pxxx123 -hpablo --opt --single-transaction --skip-add-locks mydb alerts_daily | gzip -1 > /tmp/any_time_alerts_daily.sql.gz&
mysqldump -uroot -pxxx123 -hmarvin --opt --single-transaction --skip-add-locks mydb candles_5m | gzip -1 > /tmp/any_time_candles_5m.sql.gz&
mysqldump -uroot -pxxx123 -hfive_towns --opt --single-transaction --skip-add-locks mydb candles_d | gzip -1 > /tmp/any_time_candles_d.sql.gz&
#This next line could be broken up better.
mysqldump -uroot -pxxx123 -hharvey --opt --single-transaction --skip-add-locks archive | gzip -1 > /tmp/archive.sql.gz&