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.
Has anyone implemented such a schedule and if so is this how you did it? If there's anyone else who has any input, I'd appreciate it if you could share it.
Many thanks,
Joe
------------------------------------------------------------------------------
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
|