[mythtv-users] Really nice MySQL backup script

[Intense Red]

 > I found a really nice MySQL backup script that handles daily, weekly,
 > and monthly rotations.

   FWIW, here's the one that I use.  With Debian, if I want daily (weekly, 
monthly, etc.) backups I just put the backup script into /etc/cron.daily 
(etc.) or a similar subdirectory.

- - - snip - - -
#!/bin/sh

# Dump all databases on the SQL server:

USER=root

# ***Edit the below variable: ***
PASSWORD=YourMySqlRootPassword

HOST=localhost
HOSTNAME=`cat /etc/hostname`

# ***Edit the below variable: ***
# No trailing slash below!
BACKUPDIR=/backups

TIMESTAMP=`date +%y%m%d`

for EachDatabase in $(echo 'SHOW DATABASES;' |
mysql -u$USER -p$PASSWORD -h$HOST|grep -v '^Database$');
   do
      nice -n 10 mysqldump \
         -u$USER -p$PASSWORD -h$HOST \
         -Q -c -C --add-drop-table --add-locks --quick --lock-tables \
         $EachDatabase > $BACKUPDIR/$HOSTNAME-$EachDatabase-$TIMESTAMP.sql
      nice -n 17 bzip2 $BACKUPDIR/$HOSTNAME-$EachDatabase-$TIMESTAMP.sql
done;

- - - snip - - -


-- 
"But woe unto you that are rich! for ye have received your consolation." -- 
Jesus Christ, The Holy Bible, Luke 6:24. (Note He said "woe unto" and 
not "give more tax breaks to".)