On Wed, 22 Feb 2012 08:29:22 -0500, John Drescher wrote: > 2012/2/22 <joenyl...@me.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users