Rotation failed if DB Name using -

[Exilist]

How to configure this 2 Databases for rotation:

-homepage
-homepage-phase2

My Bashup Config already includes:

ROTATE_LOCATION=${BACKUP_DEST_BASE}/mysql/homepage-*

so this also effects ${BACKUP_DEST_BASE}/mysql/homepage-phase2-*

[Anselm Helbig (anselm-helbig)]

Well, this behavior is expected. Of course a pattern of homepage-* also matches homepage-phase2-something in the same directory. If all your backups for the "homepage" database look like "homepage-2009-03-13.tar.gz", you might set ROTATE_LOCATION to "${BACKUP_DEST_BASE}/mysql/homepage-2*". The downside is that this would introduce a Y3K-bug.

[Caspar Clemens Mierau (leitmedium)]

Let me add, that you can specify the name of the dump file lile:

FILE=${BACKUP_DEST_BASE}/database-something.sql.bz2

Therefore you can develop your own name scheme that does not run into your problems, lile

FILE=${BACKUP_DEST_BASE}/001_database.sql.bz2
FILE=${BACKUP_DEST_BASE}/002_database-something.sql.bz2

This won't affect rotation as the patterns are unique.

Thank you for pointing this out, we'll consider including this hint in the man page.