Database Compression

2009-04-13T18:46:38Z

This code seems to be incorrect as well:

for database in $databases
do
rm -f ${backupdir}/${DOW}-${database}.sql.gz
rm -f ${backupdir}/sql/${DOW}-${database}.sql.gz
$gzip ${backupdir}/${DOW}-${database}.sql
done

Should read this:

for database in $databases
do
rm -f ${backupdir}/${DOW}-${database}.sql.gz #not even sure what this is supposed to do since no db files are created here
rm -f ${backupdir}/sql/${DOW}-${database}.sql.gz
gzip ${backupdir}/sql/${DOW}-${database}.sql
done

Without this change, nothing is really being accomplished.

Backing up multiple databases

2009-04-13T18:38:26Z

There appears to be an error in the code on line 31. It reads this:

$mysqldumpcmd $userpassword $dumpoptions $databases > ${backupdir}/sql/${DOW}-${database}.sql

It should read this:

$mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/sql/${DOW}-${database}.sql

The key is $database instead of $databases before the dump.

Recent changes to bugs

Database Compression

Backing up multiple databases