-   Linux - Server (
-   -   bacula - trying to backup a file with a changing name? (

neocontrol 05-07-2008 10:07 AM

bacula - trying to backup a file with a changing name?
Okay, so I'm using automysql backup to take daily backups of our sql server.

It names things similar to this dbname_2008_05)08_01h15m.Wednesday.sql.gz

I would like bacula to grab the latest ones every day. Currently I have a script that moves the days backup to a directory and I pull from that directory.

Is it possible to have variables in my bacula files that will allow me to backup something like this?

day=`date +%a`
File = /backups/daily/*/*$day*

I looked, but it doesn't seem possible.

choogendyk 05-07-2008 08:40 PM

If you do an incremental backup of that directory, it should catch the latest changes.

But if you are trying to organize MySQL backups, why not take a look at ZRM (Zmanda Recovery Manager) for MySQL? It manages all the dumps for you, and can do incremental as well as full, tracking everything and giving you an easy management interface. You can still use whatever general backup tool you want to put those on tape, cycle them out to network storage, or whatever. I happen to use Amanda for that, but you don't have to.

All times are GMT -5. The time now is 07:05 AM.