On Wed, 22 Feb 2012 08:29:22 -0500, John Drescher wrote:
> 2012/2/22 <joenyland AT me DOT com>:
>>
>> Hi,
>>
>> I'm in the process of setting up MySQL backups in Bacula, using
>> mysqldump
>> for full backups and backing up my bin logs for incremental backups.
>>
>> What I would like to do is to perform a full backup to my full
>> backup pool
>> at 00:00 every night, then perform incremental backups to my
>> incremental
>> pool every hour thereafter.
>>
>> Just as a rough config, I have the current schedule at the moment,
>> whilst
>> testing:
>>
>> Schedule {
>> Name = "TestServer MySQL Database Schedule"
>> Run = Level=Full pool=TestServer_MySQL_Full
>> Storage=TestServer_MySQL_Full
>> daily at 00:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 01:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 02:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 03:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 04:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 05:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 06:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 07:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 08:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 09:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 10:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 11:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 12:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 13:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 14:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 15:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 16:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 17:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 18:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 19:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 20:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 21:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 22:00
>> Run = Level=Incremental pool=TestServer_MySQL_Inc
>> Storage=TestServer_MySQL_Inc daily at 23:00
>> }
>>
>> I feel that there must be another, cleaner, way to define this kind
>> of
>> backup schedule, but I can't seem to be able to find one from the
>> manual.
>>
>
> You could make the default level Incremental and the default Pool
> TestServer_MySQL_Inc in your Job and cut all overrides but the full
> however I would leave this alone. Your schedule is fine.
>
> John
Hello,
As far as I see, you only have 2 pools, one for each type.
Why don't you use hourly keyword to schedule incrementals backups ?
HTH.
Jérôme Blion.
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|