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