automysqlbackup-users

[Automysqlbackup-users] Daily Logs Don't Rotate Unless Compressed w/ gzip

[Rob R. <ro...@ro...>]

Thanks for the useful script. 

There is a bug in automysqlbackup v2.0 where daily backups aren't 
rotated if you do not use gzip for compression.

Compare the rotation call in weekly vs. that in daily.  Daily doesn't 
look for a wildcard extension, but .gz instead

                eval rm -fv "$BACKUPDIR/weekly/$DB/week.$REMW.*"
                eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.gz"

I believe the daily rotation eval statement ( line 453 for me ) should read
                eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.*"

Re: [Automysqlbackup-users] Daily Logs Don't Rotate Unless Compressed w/ gzip

[WipeOut <wip...@us...>]

Rob Rosenfeld wrote:

> Thanks for the useful script.
> There is a bug in automysqlbackup v2.0 where daily backups aren't 
> rotated if you do not use gzip for compression.
>
> Compare the rotation call in weekly vs. that in daily.  Daily doesn't 
> look for a wildcard extension, but .gz instead
>
>                eval rm -fv "$BACKUPDIR/weekly/$DB/week.$REMW.*"
>                eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.gz"
>
> I believe the daily rotation eval statement ( line 453 for me ) should 
> read
>                eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.*"
>
Well spotted Rob..

I guess that one slipped by.. Thanks for taking the time to find and fix 
the problem..

I have updated the script and will upload ver 2.1 to SF now..

Later..