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.
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.