Bacula Backup
Contents
1 intro
Start Bacula Console as root: bconsole
all comands show below are functions and options of the bacula console
2 show backup jobs of specific machine
*status client=lompetier-fd
3 restore a single file
*restore client=lompetier-fd current file=/etc/yum.conf where=/ *restore client=lompetier-fd before="2009-03-25 12:00:00" file=/etc/yum.conf where=/
4 restore multiple files (interactive)
*restore client=lompetier-fd where=/ before="2009-03-25 12:00:00" select $ help $ find *yum* $ cd etc $ ls yum* $ mark yum.repos.d $ cd .. $ cd usr $ cd local $ mark machine $ lsmark $ estimate $ done
5 restore file(s) from a specific date
in this case, replace the current option with before="YYYY-MM-DD HH:MM:SS"
e.g.:
*restore client=lompetier-fd where=/ before="2009-03-25 12:00:00" file=/etc/hosts *restore client=lompetier-fd where=/ before="2009-03-25 12:00:00" select
6 change restore location
if you want to search for differences or need logs from the past, it's nice to not overwrite the existing files.
select the option where to specify the new root. if it don't exist, bacula will create it.
e.g.:
*restore client=lompetier-fd where=/restore current file=/etc/resolv.conf *restore client=lompetier-fd where=/restore before="2009-03-25 12:00:00" select
7 a simple restore test
*restore client=prddta001-fd where=/restore before="2009-03-20 12:00:00" file=/var/log/messages
8 CAUTION
the options before and file/current have to be given in this order.
that means: first give date, then select files to restore
RIGHT: *restore client=prddta001-fd where=/restore before="2009-03-20 12:00:00" file=/var/log/messages
WRONG: *restore client=prddta001-fd where=/restore file=/var/log/messages before="2009-03-20 12:00:00"
note: this also happens in interactive mode of bacula restore
9 example restore
#> bconsole *restore client=prdhost-fd where=/home/restore before="2010-02-02 23:59:00" select *cd usr/local/bin *ls *mark checkme.sh *done
10 some links
german reference of the bacula console
http://bacula.org/manuals/de/console/console/Bacula_Console.html
english reference of restore function
http://bacula.org/en/dev-manual/Restore_Command.html
11 some Mysql Queries
status report
mysql> select JobId, Name, Type, Level, JobStatus, StartTime, RealEndTime, JobFiles, JobBytes, JobErrors, JobMissingFiles from Job where SchedTime >= SUBDATE(NOW(),INTERVAL 1 DAY) AND Type = 'B' order by StartTime; mysql> select JobId AS ID, Name, Level, JobStatus AS Status, DATE_FORMAT(StartTime,'%a %H:%i') AS Start, DATE_FORMAT(RealEndTime,'%H:%i') AS End, JobFiles AS Files, ROUND((JobBytes / 1024 / 1024 ),1) AS MByte FROM Job WHERE SchedTime >= SUBDATE(NOW(),INTERVAL 1 DAY) AND Type = 'B' order by Name;